poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 47889] New: NumberFormatException when calling XSSFCell.getStringCellValue() on cell with a string
Date Wed, 23 Sep 2009 02:01:30 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=47889

           Summary: NumberFormatException when calling
                    XSSFCell.getStringCellValue() on cell with a string
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: jeff@approximatrix.com


Created an attachment (id=24303)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24303)
Problematic worksheet

When loading the example worksheet (see attached) using POI 3.5beta6, a call to
getStringCellValue results in a number formal exception for cell A1 (first row,
first column).  This cell contains the letter 'a' only.  While the worksheet is
created with Gnumeric, it does load properly in Gnumeric and OpenOffice.

The following is the exception:

java.lang.NumberFormatException: For input string: "a"
    at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:481)
    at java.lang.Integer.parseInt(Integer.java:514)
    at
org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:257)
    at
org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:225)
...

The call on line 225 seems to suggest that the cell is identified as containing
a string.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message