Bug 46951 - Cannot parse range expressions with non-cell ref operands
Summary: Cannot parse range expressions with non-cell ref operands
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.5-dev
Hardware: All All
: P5 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-04-01 12:26 UTC by Josh Micich
Modified: 2009-04-06 01:45 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Josh Micich 2009-04-01 12:26:36 UTC
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).
Comment 1 Josh Micich 2009-04-06 01:45:47 UTC
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