The release is being voted on now. It can be found here:
I have built a release candidate for POI 3.5-FINAL. Please test-
drive and vote.
The release artifacts can be downloaded from the following url:
http://people.apache.org/~yegor/REL_3_5_FINAL
The revision number of the release is r816614 and tagged as REL_3_5-
FINAL.
Regards,
Dave
On Sep 25, 2009, at 8:29 AM, MSB wrote:
Found out a little bit more about the cause of the error but I need
to get at
the source for a few other classes in order to see why it is actually
happening.
Anyway, when you call the getStringCellValue() method, that call is
chaned
to another method the getRichTextStringValue() method - I think I have
remembered the name correctly. That method is able to determine that
the
cell contains a string - correctly - but it fails to determine that
the
value is contained in line. As a result, it thinks that the cells
value is
stored in the strings table and tries to convert the cells contents
into an
integer so that it can index into this table for the value. That is
the
source of the NumberFormatException. Currently, I do not have access
to the
source for a couple of classes CTCell and STCellType - that may help
determine the cause and indicate a possible solution. If I make
progress, I
will post.
Just a thought, Yegor is planning the imminent release of version
3.5 Final.
It may be worth seeing if you can obtain an early release of this
version of
the API to ceheck whether or not the problem has been fixed there.
Yours
Mark B
Bugzilla from [email protected] wrote:
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: [email protected]
ReportedBy: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
--
View this message in context:
http://www.nabble.com/DO-NOT-REPLY--Bug-47889--New%3A-NumberFormatException-when-calling-XSSFCell.getStringCellValue%28%29-on-cell-with-a-string-tp25570304p25614159.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
