CalculationOptions Members
Contains options used for calculation of formulas contained in the worksheet cells.
#Properties
Name | Description |
---|---|
Calculation |
Allows you to specify the version of the calculation engine used to calculate values in the workbook. |
Enable |
Gets or sets whether to enable multi-threaded calculations for the current workbook. |
Full |
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. |
Max |
Gets or sets the maximum change for iterative calculations. |
Max |
Gets or sets the number of iterations which will be performed for the iterative calculation. |
Mode | Gets or sets the document’s calculation mode. |
Precision |
Gets or sets a value indicating whether calculations in a workbook should be performed by using the precision of the number format. |
Recalculate |
Gets or sets whether formulas should be calculated when the workbook is saved. |
Thread |
Gets or sets the number of calculation threads. |
Use1904Date |
Gets or sets whether the date system used to convert a date to a serial value starts in 1904. |
See Also