CalculationModeOverride Enum

Lists calculation modes which can be applied to the loaded document, overriding its settings.

Namespace: DevExpress.XtraSpreadsheet.Import

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

Declaration

C#

public enum CalculationModeOverride

VB.NET

Public Enum CalculationModeOverride

Members

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.

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
	XlsDocumentImporterOptions.OverrideCalculationMode

Remarks

Use the CalculationModeOverride enumeration members to specify OpenXmlDocumentImporterOptions.OverrideCalculationMode and XlsDocumentImporterOptions.OverrideCalculationMode property values.