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 | Names | ReCreate 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. |