Lists modes that specify when the Spreadsheet should calculate formulas in the workbook.
Indicates that calculations in the workbook will be performed automatically when cell values change.
Indicates that data tables will be excluded during automatic calculation.
Indicates that calculations in the workbook will be triggered manually by the user.
The CalculationMode enumeration is a value of the CalculationOptions.Mode property.
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.