Doubly prefixed references

This page in 2007
Top  Previous  Next

The expression =SUM(Sheet1!A1:B5) can be written as =SUM(Sheet1!A1:Sheet1!B5).  The redundancy adds nothing, but the expression is legal in Excel.

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

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 issue.  Until it does, the workaround is to alter such expressions to remove the second prefix in the reference.