CGXFormulaSheet::SetRecalcMode
void SetRecalcMode(int nMode);
nMode
-
nMode can one of:
- GX_RECALC_AUTO for automatic recalculation
GX_RECALC_MANUAL for manual recalculation
Remarks
Objective Grid lets you decide whether or not to recalculate the spreadsheet after you make changes that affect other cells or whenever the sheet is initially loaded. Objective Grid automatically recalculates the spreadsheets in both cases if Recalculation Mode is set to Automatic. If recalculation is occupying too much time, you can turn automatic recalculation off. Objective Grid will only recalculate upon explicit request.
When Manual is set, formulas are only recomputed when an explicit recalculation operation is requested (i.e. you call Recalc). When Automatic is set, any action which causes the contents of a cell to change automatically triggers recalculation of any formulas depending on the changed cell.
See Also
CGXFormulaSheet::SetRecalcMethod