XlsDocumentImporterOptions.OverrideCalculationMode Property

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

Namespace: DevExpress.XtraSpreadsheet.Import

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

Declaration

C#

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

VB.NET

<DefaultValue(CalculationModeOverride.None)>
Public Property OverrideCalculationMode As CalculationModeOverride

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	.Xlt.OverrideCalculationMode

Remarks

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

C#

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

VB.NET

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