Where is the solver in Calc ?
The multivariable solver integrated into LibreOffice is activated by the Menu▸ .
The solver engine by default supports only linear equations, but the NLPSolver extension allows you to handle non-linear problems. You will find a full explanation of its functioning on .
Yous can also use the tool Goal seek :
- Set out the equations for your problem, with a cell to contain the initial value that is to be determined, and another containing the formula whose result needs to reach a certain value (the target value).
- Go to ▸ .
- In Formula Cell, indicate the coordinates of the cell containing the formula which needs to attain the target value.
- In Target Value, indicate the value that should be reached in the preceding case.
- In Variable Cell, indicate the coordinates of the cell whose value is unknown and will be modified.
- Click OK.
The spreadsheet will show you if it has reached the target value and will suggest inserting a suitable value into the variable cell. Failing that, it will suggest a value for the variable cell which gets you as close as possible to the target value.
It is possible to use other tools, such as the Fitoo macro, a non-linear correlation tool, created by Laurent Godard, available at .
For polynomial correlations, there is the CorelPolyGUI extension.