You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/09/20 17:30:28 UTC
DO NOT REPLY [Bug 45853] New: Date edited using Open Office not work
with POI.
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: dev@poi.apache.org
ReportedBy: avdhesh.java@gmail.com
CC: avdhesh.java@gmail.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45853] Date edited using Open Office not work with
POI.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45853
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ni...@torchbox.com> 2008-09-21 09:45:42 PST ---
What's the date format that excel outputs, and what's the one that open office
outputs? How has oo changed it? Have you tried with a recent svn checkout of
poi?
(Call getCellStyle on the cell, then getDataFormatString, that'll give you the
format string used)
--
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
DO NOT REPLY [Bug 45853] Date edited using Open Office not work with
POI.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45853
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution| |LATER
--
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
DO NOT REPLY [Bug 45853] Date edited using Open Office not work with
POI.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45853
avdhesh yadav <av...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |ASSIGNED
--- Comment #2 from avdhesh yadav <av...@gmail.com> 2008-09-22 01:23:30 PST ---
when i call cellStyle.getDataFormat(); method on the cell which contains date
for excel file ,it return 15.In case of file edited with open office it returns
data format 166.
After updating POI 3.5 beta . this problem resolved.
--
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