FormulaSettings class

Settings of formulas and calculation.

The FormulaSettings type exposes the following members:

Property	Description
calculate_on_open	Indicates whether the application is required to perform a full calculation when the workbook is opened.
calculate_on_save	Indicates whether to recalculate the workbook before saving the document, when in manual calculation mode.
force_full_calculation	Indicates whether it calculates all formulas every time when a calculation is triggered.
calculation_mode	Gets or sets the mode for workbook calculation in MS Excel.
calculation_id	Specifies the version of the calculation engine used to calculate values in the workbook.
enable_iterative_calculation	Indicates whether to enable iterative calculation to resolve circular references.
max_iteration	The maximum iterations to resolve a circular reference.
max_change	The maximum change to resolve a circular reference.
precision_as_displayed	Indicates whether the precision of calculated result be set as they are displayed while calculating formulas.
enable_calculation_chain	Indicates whether to enable calculation chain for formulas. Default is false.
preserve_padding_spaces	Indicates whether to preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas. Default value is false.