https://issues.apache.org/bugzilla/show_bug.cgi?id=45853
Summary: Date edited using Open Office not work with POI.
Product: POI
Version: 3.1
Platform: PC
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
First create a excel file using ms office. add a date (d m y) in a cell and any
string cell.Then try to read this field with poi.everything work file.poi is
able to tell us that it a date.HSSFDateUtil.isCellDateFormatted(cell) method
returns true.
Now open same excel file in openoffice.edit the cell where we added the
String.do not change the cell where we added date.save the file from excel.
This time when we try to read the excel
file.HSSFDateUtil.isCellDateFormatted(cell) method returns false.
Expected - > The file which is being edited by openoffice should be handled
properly by POI. but unfortunatly this is not the case.The written for ms excel
break when same file read/edited by using open office.POI should handle this
case.
--
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]
