CalculationOptions Members

Contains options used for calculation of formulas contained in the worksheet cells.

Properties

Name	Description
CalculationId	Allows you to specify the version of the calculation engine used to calculate values in the workbook.
EnableMultiThreading	Gets or sets whether to enable multi-threaded calculations for the current workbook.
FullCalculationOnLoad	Indicates whether formulas should be recalculated when the workbook is opened.
Iterative	Gets or sets whether the application should perform iterative calculations for formulas that contain circular references.
MaxChange	Gets or sets the maximum change for iterative calculations.
MaxIterationCount	Gets or sets the number of iterations which will be performed for the iterative calculation.
Mode	Gets or sets the document’s calculation mode.
PrecisionAsDisplayed	Gets or sets a value indicating whether calculations in a workbook should be performed by using the precision of the number format.
RecalculateBeforeSaving	Gets or sets whether formulas should be calculated when the workbook is saved.
ThreadCount	Gets or sets the number of calculation threads.
Use1904DateSystem	Gets or sets whether the date system used to convert a date to a serial value starts in 1904.