Issue 123136

Summary: Solver ignores setting "Assume variables as integer"
Product: Calc Reporter: Edwin Sharp <elish>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: 3.4.0Keywords: regression
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Issue Type: DEFECT Latest Confirmation in: 4.0.0
Developer Difficulty: ---
Attachments:
Description Flags
Solver example spreadsheet none

Description Edwin Sharp 2013-08-29 07:21:39 UTC 
Created attachment 81408 [details]
Solver example spreadsheet

Tools - Solver... - Options... - check assume variables as integer
check also assume variables as non-negative
Result of cell A1 is 4.6 (not an integer!) when B1 target is -27.
See attachment

Rev. 1516794 Win 7
Comment 1 Rainer Bielefeld 2013-09-04 10:21:20 UTC 
a) Reproducible with  "AOO 4.0.0 – German UI / German locale  [AOO400m3(Build:9702)  -  Rev. 1503704 2013-07-16 14:54:56 (Di, 16 Jul 2013)]" on German German WIN7 Home Premium (64bit)", Common 4.0-dev User Profile.

b) Not a new problem, already reproducible with AOO 3.4.0

c) Still worked fine with OOo 3.1.1, OOo 3.3.0, so REGRESSION

d) Still reproducible with  "AOO 4.1.0-Dev – English  UI / German locale - [AOO410m1(Build:9750)  -  Rev. 1516435  2013-08-24]" on German WIN7 Home
Premium (64bit)", own separate user profile. so FIXED

e) It seems the solver also ignores Limiting conditions? A1 Result "4.6" is not in
   accordance with limitation "A1 >= 25"? But I don't know enough concerning 
   solver. But so, for example, LibO 4.0.3 says "no solution possible" for
   reporter's sample

f) Works fine with LibO 4


@Edwin Sharp:
Can you please do some research concerning 'e' and submit a new bug for that if you also see that a a bug (what has not been reported yet)?