The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

CalculationMode Enum

Lists modes that specify when the Spreadsheet should calculate formulas in the workbook.

Namespace: DevExpress.Spreadsheet

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

Declaration

public enum CalculationMode
Public Enum CalculationMode
public enum CalculationMode
Public Enum CalculationMode

Members

Name Description
Automatic

Indicates that calculations in the workbook will be performed automatically when cell values change.

AutomaticExceptTables

Indicates that data tables will be excluded during automatic calculation.

Manual

Indicates that calculations in the workbook will be triggered manually by the user.

Remarks

The CalculationMode enumeration is a value of the CalculationOptions.Mode property.

When the calculation mode is Manual, use the IWorkbook.Calculate, Range.Calculate or the Worksheet.Calculate methods to force calculation.

After the Manual calculation mode is switched to Automatic, the cells, marked for calculation, are calculated, but are not always redrawn. To redraw the cells immediately, call the SpreadsheetControl.Refresh method.

See Also