officefileapi-devexpress-dot-spreadsheet-dot-calculationoptions.md
Gets or sets the document’s calculation mode.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
CalculationMode Mode { get; set; }
Property Mode As CalculationMode
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to Mode |
|---|---|
| DocumentSettings |
.Calculation .Mode
|
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.
See Also