CalculationModeOverride Enum

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

Namespace: DevExpress.XtraSpreadsheet.Import

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public enum CalculationModeOverride

VB.NET

Public Enum CalculationModeOverride

Members

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.

Related API Members

The following properties accept/return CalculationModeOverride values:

Library	Related API Members
WPF Controls	SpreadsheetOpenXmlImportOptions.OverrideCalculationMode
	SpreadsheetXlsImportOptions.OverrideCalculationMode
	SpreadsheetXlsmImportOptions.OverrideCalculationMode
Office File API	OpenXmlDocumentImporterOptions.OverrideCalculationMode
	XlsbDocumentImporterOptions.OverrideCalculationMode
	XlsDocumentImporterOptions.OverrideCalculationMode