## FormulaSettings class

Settings of formulas and calculation.



The FormulaSettings type exposes the following members:

### Properties
| Property | Description |
| :- | :- |
| [calculate_on_open](/cells/python-net/aspose.cells/formulasettings/calculate_on_open) | Indicates whether the application is required to perform a full calculation when the workbook is opened. |
| [calculate_on_save](/cells/python-net/aspose.cells/formulasettings/calculate_on_save) | Indicates whether recalculate the workbook before saving the document, when in manual calculation mode. |
| [force_full_calculation](/cells/python-net/aspose.cells/formulasettings/force_full_calculation) | Indicates whether calculates all formulas every time when a calculation is triggered. |
| [calculation_mode](/cells/python-net/aspose.cells/formulasettings/calculation_mode) | Gets or sets the mode for workbook calculation in ms excel. |
| [calculation_id](/cells/python-net/aspose.cells/formulasettings/calculation_id) | Specifies the version of the calculation engine used to calculate values in the workbook. |
| [enable_iterative_calculation](/cells/python-net/aspose.cells/formulasettings/enable_iterative_calculation) | Indicates whether enable iterative calculation to resolve circular references. |
| [max_iteration](/cells/python-net/aspose.cells/formulasettings/max_iteration) | The maximum iterations to resolve a circular reference. |
| [max_change](/cells/python-net/aspose.cells/formulasettings/max_change) | The maximum change to resolve a circular reference. |
| [precision_as_displayed](/cells/python-net/aspose.cells/formulasettings/precision_as_displayed) | Whether the precision of calculated result be set as they are displayed while calculating formulas |
| [enable_calculation_chain](/cells/python-net/aspose.cells/formulasettings/enable_calculation_chain) | Whether enable calculation chain for formulas. Default is false. |
| [preserve_padding_spaces](/cells/python-net/aspose.cells/formulasettings/preserve_padding_spaces) | Indicates whether preserve those spaces and line breaks that are padded between formula tokens
<br/>while getting and setting formulas.
<br/>Default value is false. |



### See Also
* module [`aspose.cells`](..)