SpreadsheetOpenXmlImportOptions.OverrideCalculationMode Property
Gets or sets how the calculation mode should be changed for the loaded OpenXML (.XLSX) 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 the 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 .xlsx 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.OpenXml.OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual;