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 2013/12/23 17:00:13 UTC
[Bug 55927] New: [PATCH] poi xml export can't handle date types
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
Bug ID: 55927
Summary: [PATCH] poi xml export can't handle date types
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: hae@zuehlke.com
It fails to export a date type because the cell value is interpreted as a
double type.
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
--- Comment #1 from Marc <ha...@zuehlke.com> ---
Created attachment 31148
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31148&action=edit
[PATCH] patch
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |PatchAvailable
Status|REOPENED |NEW
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
Marc <ha...@zuehlke.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|FIXED |---
--- Comment #5 from Marc <ha...@zuehlke.com> ---
Reopenend because POI fails to export cells containing formulas which return a
date value.
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
Thanks for the patch, committed in r1564011. This will not make it into 3.10
any more, but be included in the next release.
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #6 from Nick Burch <ap...@gagravarr.org> ---
Thanks for this, applied (with minor tweaks) in r1614696.
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
--- Comment #4 from Marc <ha...@zuehlke.com> ---
The patch I provied on december 23 does not take into account formulas which
return dates.
E.g. POI does not handle excel cells correctly containing formulas like:
=Date(2013;12;31)
The POI XML exports results into a numeric value instead of a date string.
I wrote a patch for the current trunk code which handles that correctly.
--
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
[Bug 55927] [PATCH] poi xml export can't handle date types
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55927
Marc <ha...@zuehlke.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #31148|0 |1
is obsolete| |
--- Comment #3 from Marc <ha...@zuehlke.com> ---
Created attachment 31821
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31821&action=edit
Exports formulas correctly to a xml document
--
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