CalculationOptions.Mode Property

Gets or sets the document’s calculation mode.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

CalculationMode Mode { get; set; }

VB.NET

Property Mode As CalculationMode

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.