DO NOT REPLY [Bug 9033] New: - enetering a formula with a sheet reference such as sum(sheet2:sheet3!A16) causes s numberFormatException

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=9033>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=9033

enetering a formula with a sheet reference such as sum(sheet2:sheet3!A16) causes s 
numberFormatException

           Summary: enetering a formula with a sheet reference such as
                    sum(sheet2:sheet3!A16) causes s numberFormatException
           Product: POI
           Version: 2.0-dev
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


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)

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>