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
|