SpreadsheetOpenXmlImportOptions.OverrideCalculationMode Property

Specifies how to change the calculation mode for a loaded document.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v20.2.dll

NuGet Packages: DevExpress.WindowsDesktop.Wpf.Spreadsheet, DevExpress.Wpf.Spreadsheet

Declaration

C#

public CalculationModeOverride OverrideCalculationMode { get; set; }

VB.NET

Public Property OverrideCalculationMode As CalculationModeOverride

Property Value

Type	Description
CalculationModeOverride	An enumeration member that specifies the calculation mode for a loaded document.

Available values:

Name	Description
None	Uses the calculation mode specified in the document (this value is stored in the CalculationOptions.Mode property).
AutomaticExceptTables	Recalculates all formulas except data tables.
Manual	A user triggers calculations in the document.
Automatic	Recalculates all formulas in the document each time a cell value, formula, or defined name changes.

Property Paths

You can access this nested property as listed below:

Object Type	Path to OverrideCalculationMode
SpreadsheetImportOptions	.OpenXml .OverrideCalculationMode

Remarks

The example below shows how to override the calculation mode when you load an XLSX file into the Spreadsheet control.

C#

spreadsheetControl.Options.Import.OpenXml.OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual;

VB.NET

spreadsheetControl.Options.Import.OpenXml.OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual