Frequently asked questions - Calc

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

Where is the solver in Calc ?

The multivariable solver integrated into LibreOffice is activated by the Menu Tools ▸ Solver.

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 [1].

Yous can also use the tool Goal seek :

1. 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).
2. Go to Tools ▸ Goal Seek.
3. In Formula Cell, indicate the coordinates of the cell containing the formula which needs to attain the target value.
4. In Target Value, indicate the value that should be reached in the preceding case.
5. In Variable Cell, indicate the coordinates of the cell whose value is unknown and will be modified.
6. 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 [2].

For polynomial correlations, there is the CorelPolyGUI extension.