Apache OpenOffice (AOO) Bugzilla – Issue 110189
OO Solver fails where MS solver works
Last modified: 2014-03-25 09:56:37 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.
Created attachment 68390 [details] Screen Prints of spreadsheets and working sheets
Created attachment 68391 [details] Initial view in OO Scalc
Created attachment 68392 [details] The actual Scalc file
Created attachment 68394 [details] The Excel file
Created attachment 68395 [details] The result of running MS Solver
Created attachment 68396 [details] The setup before running MS Solver
No solution with Rev. 1507307. Successful with Excel 2007.
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.
well the buttons that triggers the scripts are still not working but that is a different problem with VBA