next up previous contents index
Next: 6.1.3 Iterative Calculations Up: 6.1 How NExS Calculates Previous: 6.1.1 Mode of Recalculation

6.1.2 Method of Recalculation

 

Automatic recalculation supports two methods of recalculations: Foreground and As Needed.

Foreground

   

When Foreground is set, NExS 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 in the Recalc Options dialog is set to Automatic and the method is set to Foreground.

As Needed

   

When As Needed is set NExS 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 in the Recalc Options dialog is set to Automatic and method is set to As Needed.


Note that As Needed does not support Constraint Checking and Iterative Recalculation options.


next up previous contents index
Next: 6.1.3 Iterative Calculations Up: 6.1 How NExS Calculates Previous: 6.1.1 Mode of Recalculation

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999