The following code: cell.setCellFormula("SUM(C1:OFFSET(C1,0,B1))"); fails with this exception: org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Specified named range 'OFFSET' does not exist in the current workbook. This bug was noticed while fixing bug 46948 , which is concerned about evaluation of the corresponding Ptg array (pre-parsed by Excel).
This turned out to be a much bigger change than expected. Expressions like "A!A1:A!B2" are not easily handled by recursive descent parsing. Fixed in svn r762250 Several junits added