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.