Issue 110189 - OO Solver fails where MS solver works
Summary: OO Solver fails where MS solver works
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO320m9
Hardware: PC Windows XP
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on: 124158
Blocks:
  Show dependency tree
 
Reported: 2010-03-17 12:32 UTC by foot
Modified: 2014-03-25 09:56 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Screen Prints of spreadsheets and working sheets (374.94 KB, text/plain)
2010-03-17 12:35 UTC, foot 		no flags Details
Initial view in OO Scalc (323.31 KB, text/plain)
2010-03-17 12:36 UTC, foot 		no flags Details
The actual Scalc file (11.80 KB, text/plain)
2010-03-17 12:37 UTC, foot 		no flags Details
The Excel file (70.50 KB, text/plain)
2010-03-17 12:38 UTC, foot 		no flags Details
The result of running MS Solver (423.01 KB, text/plain)
2010-03-17 12:40 UTC, foot 		no flags Details
The setup before running MS Solver (427.46 KB, text/plain)
2010-03-17 12:41 UTC, foot 		no flags Details
test with updated CoinMP 1.7.6 on aoo trunk rev. 1580882 (139.58 KB, image/png)
2014-03-25 09:47 UTC, jsc 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description foot 2010-03-17 12:32:54 UTC 
In the attached samples, when applying Solver to the data attached, all the
answers end up as showing divide by 0.  When using Excel with the same data the
correct solution is found.

attachments  OO Solver 1.jpg   all set before applying solver
             OO Solver 2.jpg   the result
             MS Solver 1.jpg   all set before applying solver
             MS Solver 2.jpg   the result

             OO Solver Test.ods  the spreadsheet used with initial data
             Statistical Failure analysis.xls  the same in Excel
I can't see how to attach these data to my submission.  Please let me know where
I can send them.
Comment 1 foot 2010-03-17 12:35:51 UTC 
Created attachment 68390 [details]
Screen Prints of spreadsheets and working sheets
Comment 2 foot 2010-03-17 12:36:47 UTC 
Created attachment 68391 [details]
Initial view in OO Scalc
Comment 3 foot 2010-03-17 12:37:20 UTC 
Created attachment 68392 [details]
The actual Scalc file
Comment 4 foot 2010-03-17 12:38:01 UTC 
Created attachment 68394 [details]
The Excel file
Comment 5 foot 2010-03-17 12:40:14 UTC 
Created attachment 68395 [details]
The result of running MS Solver
Comment 6 foot 2010-03-17 12:41:03 UTC 
Created attachment 68396 [details]
The setup before running MS Solver
Comment 7 Edwin Sharp 2013-08-04 13:17:26 UTC 
No solution with Rev. 1507307.
Successful with Excel 2007.
Comment 8 jsc 2014-03-25 09:47:57 UTC 
Created attachment 82967 [details]
test with updated CoinMP 1.7.6 on aoo trunk rev. 1580882

I tested some files with my locally build of aoo trunk rev. 1580882 and with an updated version of CoinMP 1.7.6. Looks good to me.
Comment 9 jsc 2014-03-25 09:56:37 UTC 
well the buttons that triggers the scripts are still not working but that is a different problem with VBA