Skip to main content

XlsbDocumentImporterOptions.OverrideCalculationMode Property

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

Namespace: DevExpress.XtraSpreadsheet.Import

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

[DefaultValue(CalculationModeOverride.None)]
public CalculationModeOverride OverrideCalculationMode { get; set; }

Property Value

Type Default Description
CalculationModeOverride None

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
WorkbookImportOptions
.Xlsb .OverrideCalculationMode

Remarks

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

spreadsheetControl.Options.Import.Xlsb.OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual;
See Also