next up previous contents index
Next: 6.3 Changing Calculation Options Up: 6.2 NExS Formulas Previous: 6.2.6 Constraint Expressions

6.2.7 Explicit Dependency

   

There may be instances where you need to force a recalculation when certain cell values changes, when there is no implicit dependency in the formula that would trigger an automatic recalculation. This option is indicated by appending a backslash (\) to the end of the dependent formula. For example, the formula:
=@SUM(A1..A20)\D50
instructs NExS to recalculate @SUM(A1..A20) whenever the contents of D50 change.

This feature is particularly important when you have a constraint expression containing an offset reference that produces a cell reference outside the cell range referenced in a dependent formula. Under these circumstances, Automatic Recalculation would not necessarily be triggered. Take for instance, the example from above:

@CCOUNT(C4..C100, # > #{0,-1}) counts all the cells in the range C4..C100 whose value is greater than the contents of the cell immediately above.

In order for C4 to be evaluated, it must be compared to C3 - which is not part of the explicit range, C4..C100. Without indicating an explicit dependency, C4 would never be evaluated properly. So, in this case, we would indicate the dependency as follows:
@CCOUNT(C4..C100, # > #{0,-1})\C3..C99
which tells NExS to recalculate whenever any cell in the range C3..C99 changes.


next up previous contents index
Next: 6.3 Changing Calculation Options Up: 6.2 NExS Formulas Previous: 6.2.6 Constraint Expressions

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