.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

CalculationOptions Properties

Contains options used for calculation of formulas contained in the worksheet cells.
Name Description
CalculationId Allows specifying 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 Gets or sets a value indicating 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.
See Also