SpreadsheetXlsImportOptions.OverrideCalculationMode Property
Specifies how to change the calculation mode for a loaded document.
Namespace: DevExpress.Xpf.Spreadsheet
Assembly: DevExpress.Xpf.Spreadsheet.v24.2.dll
NuGet Package: DevExpress.Wpf.Spreadsheet
#Declaration
public CalculationModeOverride OverrideCalculationMode { get; set; }
#Property Value
Type | Description |
---|---|
Calculation |
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 Calculation |
Automatic |
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 Override |
---|---|
Spreadsheet |
|
#Remarks
The example below shows how to override the calculation mode when you load an XLS file into the Spreadsheet control.
spreadsheetControl.Options.Import.Xls.OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual;