CGXFormulaSheet::SetRecalcMethod
void SetRecalcMethod(int nMethod);
nMethod
-
nMethod can be one of:
- GX_RECALC_AS_NEEDED for As Needed recalculation
GX_RECALC_FOREGROUND for foreground recalculation
Remarks
Recalculation Method defines how Objective Grid will proceed with recalculation.
Automatic recalculation supports two methods of recalculations: Foreground and As Needed.
Foreground
When Foreground is set, Objective Grid enforces minimal recalculation, which means that only the cells in the spreadsheet which are potentially affected by an operation which you perform (such as editing a cell, or moving a range of cell) are recalculated. This feature minimizes the work performed during recalculation and thus speeds up your computations. Minimal recalculation is in effect whenever the recalculation mode is set to Automatic and the method is set to Foreground.
As Needed
When As Needed is set Objective Grid enforces frugal recalculation, which further reduces the number of cell that need to be computed. The performance gain in recalculation can be significant, depending on the size and complexity of the sheet. Frugal recalculation is in effect whenever the recalculation mode is set to Automatic and method is set to As Needed.
See Also
CGXFormulaSheet::SetRecalcMode
