I'm reporting this bug in the Windows release of LO. I have experienced this under releases 220.127.116.11 and 18.104.22.168.
I’m using the solver to find the minimum of a non-linear function calculated in the spreadsheet found here:
The optimized quantity is a sum-of-squares error, cell A134, and the value in this cell should fall to 10 or less. I set up the solver to find a minimum by manipulating the values in cells F13 through F17. The initial values I choose are F13=1.0 and the other set to zero.
The solver runs for what seems like a long time (more than a minute on my machine) and makes some progress reducing the error. Then it, and calc, crash and close. This happens every time. In the LO Calc solver, I have tried both the DEPS and SCO algorithms and both only make very slow progress and then crash.
When I open the spreadsheet in Excel and use its solver (the GRG nonlinear algorithm) to perform the minimization from the same initial conditions (and others) it finishes in about 1-2 seconds and never crashes. This seems to indicate that the minimization problem itself is not the cause of the crashing behavior. Also, I reported this bug on another forum, and a user there could not reproduce the crash under GNU/Linux running LO v4.1 and v4.2 so it might be a LO Windows build-specific problem.
I confirmed this bug. Changing status to highest blocker since this bug always causes LO to close.
MSO 2013 returns a value of 0.016671001 in less than 2 seconds.
I tested using:
Build ID: 61cb170a04bb1f12e77c884eab9192be736ec5f5
(This is an automated message.)
LibreOffice development currently prioritizes bugs with the so called MAB (most annoying bugs) -- as this bug has not run through that process (including writing a short rationale for this bug being a candidate and other who are watching the tracker bug silently approving that rationale etc.) its priority is set to high. Note this is effectively no change in the urgency assigned to this bug, as we are currently not making a difference between high and highest and severity is untouched.
You can find out more about MABs and how the process works by contacting libreoffice qa on irc:
The QA wiki page also gives you hints on how to get in contact with the team (if IRC fails you, your next best choice is the mailing list):
Created attachment 107490 [details]
XLS file referenced by the original bug report
I added the file provided as a link by the original bug author so that our testing infrastructure can pick it up.
Blockers are reserved for developers and the release engineers. If that would have been a blocker it would have been brought to the attention of the ESC already and as we see it did not block any release.
Confirming also on OSX 10.10.1
How to reproduce
1) Open an empty Calc document
2) Navigate to Tools > Solver
3) Spinning beachball appears, leading to sudden window closure SIGABRT
Tested on master 4500alpha OSX 10.10.1
Enclosing Apple call trace
Application Specific Information:
terminating with unexpected exception of type com::sun::star::loader::CannotActivateFactoryException
Created attachment 112487 [details]
Apple call trace
Created attachment 112546 [details]
Full backtrace with master 4500alpha
Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72
Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8
Build ID: 3a87456aaa6a95c63eea1c1b3201acedf0751bd5
*** Bug 88544 has been marked as a duplicate of this bug. ***
Solver works with LO Calc 22.214.171.124 without the "Solver for nonlinear programming 0.9" extension under Windows 7, successfully minimizing a quadratic. However, with this extension, Solver kills Calc saying, "LibreOffice quit unexpectedly" with LO 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11 under Mac OS X 10.10.1 and 18.104.22.168 under Windows 7. With LO 22.214.171.124 under Ubuntu 14.04 LTS without this extension when asked to minimize a quadratic (A1=1, A2=2, A3=(a1-a2)*(a1-a2), min. a3 by varying A1), it displays a different error message: "No solution was found. The model is not linear." I can't find how to install this extension under Ubuntu nor how to delete it under any of the other operating systems. However, I got this same message under LO 126.96.36.199 under Mac OS X 10.10.1. In that case, I was able to install the extension and convert the "No solution" message to "LO quit unexpectedly". If someone can help me install the "Solver for nonlinear programming 0.9" under Ubuntu or remove or disable it elsewhere, I can do more tests. Thanks for your support of LibreOffice. As I said for another FOSS project, people all over the world live better today because of your contributions to this project. Spencer Graves
Created attachment 112903 [details]
OSX - fragment of SAL_LOG=yes output
The attached fragment of SAL_LOG=yes output suggests that for OSX at least we are trying to load libCbc.3.dylib from the wrong place when Solver is invoked
Setting Whiteboard - notBibisectable; this is a Windows and OSX only bug, and doesn't appear to be in the bibisect range available for OSX
The OSX problem mentioned above turns out to be unrelated, and will be fixed on bug 80370.
This bug report is for an issue that is specific to Windows, as reported in comment 0 and confirmed in comment 1
Created attachment 112905 [details]
Screenshot: solving with 4.5 alpha from Jan 25 2015
It didn't crash, but am I doing it right?
Win 7 Pro 64-bit Version: 188.8.131.52.alpha0+
Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36
Setting to NEEDINFO as I'm not sure, what the exact reproduction steps are.
FIXED in LO 184.108.40.206alpha0_MacOS_x86-64.dmg under OS X 10.10.1 and OS X 10.10.2. To be precise, it worked with my toy example A1=1, A2=2, A3=(A1-A2)^2, Tools -> Solver -> minimize A3 by varying A1. Answer was close to 2 in 10.10.1 and displayed as exactly 2 in 10.10.2. Much thanks to the LO developers!
Thanks for testing. Setting to WFM per comment 20.
Migrating Whiteboard tags to Keywords: (notBibisectable)