Back to Devexpress

CalculationModeOverride Enum

officefileapi-devexpress-dot-xtraspreadsheet-dot-import-8c3a9549.md

latest2.4 KB
Original Source

CalculationModeOverride Enum

Lists values used to override the calculation mode for a loaded document.

Namespace : DevExpress.XtraSpreadsheet.Import

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public enum CalculationModeOverride
vb
Public Enum CalculationModeOverride

Members

NameDescription
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.

|

The following properties accept/return CalculationModeOverride values:

LibraryRelated API Members
WPF ControlsSpreadsheetOpenXmlImportOptions.OverrideCalculationMode
SpreadsheetXlsImportOptions.OverrideCalculationMode
SpreadsheetXlsmImportOptions.OverrideCalculationMode
Office File APIOpenXmlDocumentImporterOptions.OverrideCalculationMode
XlsbDocumentImporterOptions.OverrideCalculationMode
XlsDocumentImporterOptions.OverrideCalculationMode

See Also

DevExpress.XtraSpreadsheet.Import Namespace