Back to Devexpress

CalculationOptions Members

officefileapi-devexpress-dot-spreadsheet-dot-calculationoptions-dot-underscore-members.md

latest2.3 KB
Original Source

CalculationOptions Members

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

Properties

NameDescription
CalculationIdAllows you to specify the version of the calculation engine used to calculate values in the workbook.
EnableMultiThreadingGets or sets whether to enable multi-threaded calculations for the current workbook.
FullCalculationOnLoadIndicates whether formulas should be recalculated when the workbook is opened.
IterativeGets or sets whether the application should perform iterative calculations for formulas that contain circular references.
MaxChangeGets or sets the maximum change for iterative calculations.
MaxIterationCountGets or sets the number of iterations which will be performed for the iterative calculation.
ModeGets or sets the document’s calculation mode.
PrecisionAsDisplayedGets or sets a value indicating whether calculations in a workbook should be performed by using the precision of the number format.
RecalculateBeforeSavingGets or sets whether formulas should be calculated when the workbook is saved.
ThreadCountGets or sets the number of calculation threads.
Use1904DateSystemGets or sets whether the date system used to convert a date to a serial value starts in 1904.

See Also

CalculationOptions Interface

DevExpress.Spreadsheet Namespace