SpreadsheetXlsImportOptions.OverrideCalculationMode Property
Gets or sets how the calculation mode should be changed for the loaded .XLS document.
Namespace: DevExpress.Xpf.Spreadsheet
Assembly: DevExpress.Xpf.Spreadsheet.v18.2.dll
Declaration
Property Value
Type | Description |
---|---|
CalculationModeOverride | A DevExpress.XtraSpreadsheet.Import.CalculationModeOverride enumeration member that specifies new calculation mode applied to the loaded document. |
Available values:
Name | Description |
---|---|
None | Use calculation mode as specified in the loaded document (do not override). |
AutomaticExceptTables | Tables are excluded during automatic calculation. |
Manual | Calculations in the workbook are triggered manually by the user. |
Automatic | Calculations in the workbook are performed automatically when cell values change. |
Property Paths
You can access this nested property as listed below:
Object Type | Path to OverrideCalculationMode |
---|---|
SpreadsheetImportOptions |
|
Remarks
If the original .xls document has been saved with the automatic calculation mode setting, you can use the following code to switch the calculation mode to manual when the SpreadsheetControl loads the document:
spreadsheetControl.Options.Import.Xls.OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual;