Lists modes that specify when the Spreadsheet should calculate formulas in the workbook.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.2.Core.dll
| 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. |
The CalculationMode enumeration is a value of the CalculationOptions.Mode property.
When the calculation mode is Manual, use the IWorkbook.Calculate, CellRange.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.