Doubly prefixed references

This page in 2003
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

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