Skip to main content
Row

CalculationOptions.Mode Property

Gets or sets the document’s calculation mode.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

CalculationMode Mode { get; set; }

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
.Calculation .Mode

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.

See Also