Solver Options /text/scalc/01/solver_options.xhp solver for Calc;options

Solver Options

Use the Options dialog to configure the solver engine.

Click OK to accept the changes and to go back to the Solver dialog.

Solver engine

Select a solver engine. The listbox is disabled if only one solver engine is installed. You can install more solver engines as extensions, if available. Open Tools - Extensions and browse to the Extensions web site to search for extensions.

Settings

Configure the current solver. In the Settings box, check all settings that you want to use for the current goal seeking operation. If the current option offers different values, the Edit button is enabled. Click Edit to open a dialog where you can change the value.

Edit

If the current entry in the Settings listbox allows you to edit a value, you can click the Edit button. A dialog opens where you can change the value.

Edit settings spin box

Enter or change the value of the selected setting.

Wiki page on non-linear solvers and their algorithms