Bug 9033 - [RFE] enetering a formula with a sheet reference such as sum(sheet2:sheet3!A16) causes s numberFormatException
Summary: [RFE] enetering a formula with a sheet reference such as sum(sheet2:sheet3!A1...
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: PC All
: P3 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-05-13 13:45 UTC by pete jackson
Modified: 2009-04-17 11:30 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description pete jackson 2002-05-13 13:45:09 UTC 
java.lang.NumberFormatException: 
	at java.lang.Integer.parseInt(Integer.java:426)
	at java.lang.Integer.parseInt(Integer.java:454)
	at org.apache.poi.hssf.util.ReferenceUtil.getXYFromReference
(ReferenceUtil.java:42)
	at org.apache.poi.hssf.util.ReferenceUtil.getXYXYFromAreaRef
(ReferenceUtil.java:25)
	at org.apache.poi.hssf.record.formula.AreaPtg.(AreaPtg.java:90)
	at org.apache.poi.hssf.record.formula.FormulaParser.Ident
(FormulaParser.java:252)
	at org.apache.poi.hssf.record.formula.FormulaParser.Factor
(FormulaParser.java:304)
	at org.apache.poi.hssf.record.formula.FormulaParser.Term
(FormulaParser.java:339)
	at org.apache.poi.hssf.record.formula.FormulaParser.Expression
(FormulaParser.java:384)
	at org.apache.poi.hssf.record.formula.FormulaParser.Arguments
(FormulaParser.java:285)
	at org.apache.poi.hssf.record.formula.FormulaParser.Ident
(FormulaParser.java:244)
	at org.apache.poi.hssf.record.formula.FormulaParser.Factor
(FormulaParser.java:304)
	at org.apache.poi.hssf.record.formula.FormulaParser.Term
(FormulaParser.java:339)
	at org.apache.poi.hssf.record.formula.FormulaParser.Expression
(FormulaParser.java:384)
	at org.apache.poi.hssf.record.formula.FormulaParser.parse
(FormulaParser.java:422)
	at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
(HSSFCell.java:701)
Comment 1 Andy Oliver 2002-05-13 14:17:31 UTC 
changed to RFE -- HSSF does not yet support sheet references.
Comment 2 Avik Sengupta 2003-10-27 17:50:42 UTC 
We can now do sheet references, but still cannot do Z axis ranges. ie, we can do
sum(Sheet2!A1:A16) but cannot yet do sum(sheet2:sheet3!A16)

Sorry!
Comment 3 Yegor Kozlov 2009-04-17 11:30:53 UTC 
The problem is not reproducible with the latest trunk.  

Please try the latest svn version .
Daily builds are available at
http://encore.torchbox.com/poi-svn-build/

Regards,
Yegor