3-D references

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

•OAK4 | Formula | Reconstruct

•OAK4 | Formula | Optimize

•OAK4 | Formula | Prune

•OAK4 | Names | ReDefine Name

•OAK4 | Names | ReCreate Names

•OAK4 | Names | DeApply Names

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.