OpenXmlDocumentImporterOptions.OverrideCalculationMode Property
Specifies how to change the calculation mode for a loaded document.
Namespace: DevExpress.XtraSpreadsheet.Import
Assembly: DevExpress.Spreadsheet.v23.2.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 |
|
| WorkbookImportOptions |
|
Remarks
The example below shows how to override the calculation mode when you load an XLSX file into the Spreadsheet control.
spreadsheetControl.Options.Import.OpenXml.OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual;