Structured references

Excel 2003 introduced, and Excel 2007 has developed, a notion of structured references, a means of identifying the elements of a table that are to be acted on by a formula.

The parser built in to OAK does not handle this kind of reference.  If it encounters one, it will report that "An error has occurred in OAK".

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 intends to fix this issue in due course, but does not consider it urgent as it has yet to encounter a spreadsheet prepared by a client that uses this feature.  

If you disagree with this perception and find this limitation troublesome, please let Operis know by email to oak@operis.com .