next up previous contents index
Next: 4.14 Compatibility with Microsoft Up: 4. Built-in Functions Previous: 4.12 Specifying Arguments to   Contents   Index


4.13 Computed Cell References

Several SpreadScript functions such as CELLREF and RANGEREF return a result that is itself a cell reference or range reference. This is a powerful facility, but it must be used with caution because SpreadScript can not take these indirect references into account when determining the order of recalculation. The same caution applies to constraint expressions used in conditional statistical functions. As a rule, cells that are indirectly referenced by a function are not automatically recalculated. SpreadScript provides a special construct to force a recalculation, referred to as an explicit dependency. See Section 3.2.7 for more information on creating formulas with explicity dependencies.


next up previous contents index
Next: 4.14 Compatibility with Microsoft Up: 4. Built-in Functions Previous: 4.12 Specifying Arguments to   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003