I wanted to solve a linear program (using Calc 5.2.3.3 on Arch Linux), but I can’t seem to access the options for the linear solver engine. The only options displayed are those from the non-linear engine.
Libreoffice is supposed to have the linear solver included, what am I missing here?
It used to work in the LO 4 series.
Thanks
OK, it’s not a bug, in order to have the linear solver “appear”, you need to install the package “coin-or-mp” (Arch Linux) and its dependencies. Interestingly this package is neither marked as “required” nor “optional” by pacman.
Once you have the package(s) installed you have even two linear solver engines available. The “original” and the “coin-mp” solver.
Try - from menu Tools->Solver Then Options button and then on the top of the Options dialog use the dropdown (Solver engine):
Sorry, if my question was not clear enough. I know the options diaglogue, but the linear solver is missing from the “solver engine” drop-down. For some reason I can only access the options for the --non-linear-- solvers.
The display in the answer is from LO v5.2.3.3 (on Mint 18) but it is a version directly from LibreOffice. Are you using a version from your distro? This has been a problem on occasion in the past.
Thanks, I will open a bug report for Arch then.
(comment from OP copied here as answer by AK)
OK, it’s not a bug, in order to have the linear solver “appear”, you need to install the package “coin-or-mp” (Arch Linux) and its dependencies. Interestingly this package is neither marked as “required” nor “optional” by pacman. Once you have the package(s) installed you have even two linear solver engines available. The “original” and the “coin-mp” solver.