CalculationOptions.Mode Property | Office File API | DevExpress Documentation Skip to main content
Row

CalculationOptions.Mode Property

Gets or sets the document’s calculation mode.

Namespace: DevExpress.Spreadsheet

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

Declaration

CalculationMode Mode { get; set; }

Property Value

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:

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
Use of this site constitutes acceptance of our Website Terms of Use and Privacy Policy (Updated). Cookies Settings