3-D references

This page in 2003
Top  Previous  Next

Excel allows formulas to aggregate information from a range of worksheets, as in =SUM(Alabama:Wyoming!A5:A7).

The parser built in to OAK can now make sense of this kind of reference, but the logic that processes sum expansion mishandles them.  If OAK encounters one, it will report that "An error has occurred in OAK", or generate a result that is clearly incorrect.

This issue can affect any of the functions that use OAK's Excel formula language parser, specifically

OAK Review | Formula | Reconstruct

OAK Development | Formula | Optimize

OAK Review | Formula | Prune

OAK Development | Names | Redefine

OAK Development | Names | Recreate

OAK Development | Names | Deapply

Operis is working on fixing this as these formulas are reasonably common, and because they are hard to decipher: an ability of reconstruction and discrepancy analysis to study these expressions would be particularly valuable.