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