General Information
.NET Subscription
Desktop
Web
Controls and Extensions
Mainteinance Mode
Enterprise and Analytic Tools
Quality Assurance and Productivity
Frameworks and Libraries
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
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.