Bug 46951 - Cannot parse range expressions with non-cell ref operands
Summary: Cannot parse range expressions with non-cell ref operands
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
Depends on:
Reported: 2009-04-01 12:26 UTC by Josh Micich
Modified: 2009-04-06 01:45 UTC (History)
0 users


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:

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