https://issues.apache.org/bugzilla/show_bug.cgi?id=46772
Summary: Excel 2007 Cellformat is null
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=23315)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23315)
Sample XSSF and Java sample code for reproduce
Hi,
I tryed to read a Excel 2007 OOXML file with some different cellformats, when I
wonder why some dates will be formated wrong.
POI returns for the following formats null as FormatString:
- default value cell (thats the first cell-format-option in excel, called
default)
- h:mm:ss AM/PM
- default date cell (thats the first cell-format-option unter the menu date)
- ...
So I can't modify any Formatter because there is no Format returned.
If you run the java sample attached, you will see that a lot of formats
returned null.
My sample-xlsx and the java sample code is attached.
Excel-file created with Excel 2007, german version
Used: POI 3.5 Beta4
Cheers
Oliver
--
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]
