.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

OpenXmlDocumentImporterOptions.OverrideCalculationMode Property

Gets or sets how the calculation mode should be changed for the loaded OpenXML (.XLSX) document.

Namespace: DevExpress.XtraSpreadsheet.Import

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

Declaration

[DefaultValue(CalculationModeOverride.None)]
public CalculationModeOverride OverrideCalculationMode { get; set; }
<DefaultValue(CalculationModeOverride.None)>
Public Property OverrideCalculationMode As CalculationModeOverride
[DefaultValue(CalculationModeOverride.None)]
public CalculationModeOverride OverrideCalculationMode { get; set; }
<DefaultValue(CalculationModeOverride.None)>
Public Property OverrideCalculationMode As CalculationModeOverride
[DefaultValue(CalculationModeOverride.None)]
public CalculationModeOverride OverrideCalculationMode { get; set; }
<DefaultValue(CalculationModeOverride.None)>
Public Property OverrideCalculationMode As CalculationModeOverride

Property Value

Type Default Description
CalculationModeOverride

None

A DevExpress.XtraSpreadsheet.Import.CalculationModeOverride enumeration member that specifies the new calculation mode applied to the loaded document.

Property Value

Type Default Description
CalculationModeOverride

None

A DevExpress.XtraSpreadsheet.Import.CalculationModeOverride enumeration member that specifies the new calculation mode applied to the loaded document.

Property Value

Type Default Description
CalculationModeOverride

None

A DevExpress.XtraSpreadsheet.Import.CalculationModeOverride enumeration member that specifies the new calculation mode applied to the loaded document.

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;
See Also