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] NumberFormatException when calling XSSFCell.getStringCellValue() on cell with a string
Date Sat, 26 Sep 2009 11:05:25 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=47889

Yegor Kozlov <yegor@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #2 from Yegor Kozlov <yegor@dinom.ru> 2009-09-26 04:05:23 PDT ---
Quite an interesting case. 

Firstly, Gnumeric seems to store strings in cells with type="str" which
according to the spec means "cached formula result". Both Excel and OpenOffice
tolerate it and detect such cells as of type 'string' even if the actual
formula is not assigned. I fixed POI to tolerate such worksheets too. 

The second problem is that workbooks created by Gnumeric  don't contain any
defined styles, that is, styles.xml is present but it is empty. This can crop
up in many places as cell.getCellStyle() is supposed to return a not-null
value. 
I made sure that XSSFCell.toString() works - there is a call of getCellStyle()
which resulted in exception.  

The fix was committed in r819106

Regards,
Yegor

-- 
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