CalculationOptions.Mode Property
Gets or sets the document’s calculation mode.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| CalculationMode | An enumeration member that specifies the calculation mode for a workbook. The default value is Automatic. |
Available values:
| Name | Description |
|---|---|
| Automatic | Recalculates all formulas in the document each time a cell value, formula, or defined name changes. |
| AutomaticExceptTables | Recalculates all formulas except data tables. |
| Manual | A user triggers calculations in the document. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to Mode |
|---|---|
| DocumentSettings |
|
Remarks
Use the DocumentOptions.CalculationMode property to override the document’s calculation mode and specify how the Spreadsheet control or a Workbook component should recalculate formulas.