CalculationOptions.Mode Property
Gets or sets the document’s calculation mode.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
CalculationMode Mode { get; set; }
#Property Value
Type | Description |
---|---|
Calculation |
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. |
Automatic |
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 |
---|---|
Document |
|
#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.