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 2016/03/15 14:02:20 UTC

[Bug 59183] New: New exception parsing dates with timezones offsets in OPC with POI 3.14

https://bz.apache.org/bugzilla/show_bug.cgi?id=59183

            Bug ID: 59183
           Summary: New exception parsing dates with timezones offsets in
                    OPC with POI 3.14
           Product: POI
           Version: unspecified
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: OPC
          Assignee: dev@poi.apache.org
          Reporter: tallison@mitre.org

Created attachment 33675
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33675&action=edit
Smallest triggering file

Thanks to Dominik's common crawl download tool, we now have many, many more
ooxml files for testing in Tika's regression corpus.

We're now getting the following exception in roughly 40 files with POI 3.14.

I regret that I should have caught this before the release!


java.lang.IllegalArgumentException: Date for created could not be parsed:
2012-05-21T12:56:36+02:00
    at
org.apache.poi.openxml4j.opc.internal.PackagePropertiesPart.setCreatedProperty(PackagePropertiesPart.java:393)
    at
org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller.unmarshall(PackagePropertiesUnmarshaller.java:124)
    at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:726)
    at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:230)
    at
org.apache.tika.parser.microsoft.ooxml.OOXMLExtractorFactory.parse(OOXMLExtractorFactory.java:69)

...
Caused by: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Date
2012-05-21T12:56:36+02:00Z not well formated, expected format
yyyy-MM-dd'T'HH:mm:ss'Z' or yyyy-MM-dd'T'HH:mm:ss.SS'Z'
    at
org.apache.poi.openxml4j.opc.internal.PackagePropertiesPart.setDateValue(PackagePropertiesPart.java:575)
    at
org.apache.poi.openxml4j.opc.internal.PackagePropertiesPart.setCreatedProperty(PackagePropertiesPart.java:391)
    ... 22 more

-- 
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 59183] New exception parsing dates with timezone offsets in OPC with POI 3.14

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59183

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |istvan.foldhazi@gmail.com

--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
*** Bug 59204 has been marked as a duplicate of this bug. ***

-- 
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 59183] New exception parsing dates with timezone offsets in OPC with POI 3.14

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59183

Tim Allison <ta...@mitre.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|New exception parsing dates |New exception parsing dates
                   |with timezones offsets in   |with timezone offsets in
                   |OPC with POI 3.14           |OPC with POI 3.14
                 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 59183] New exception parsing dates with timezone offsets in OPC with POI 3.14

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59183

Tim Allison <ta...@mitre.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #1 from Tim Allison <ta...@mitre.org> ---
r1735270

More code than I would have liked.  We should be able to simplify when we move
to Java 7 with "XXX" option to handle timezones with colons.  Might want to
move to ThreadLocal static SimpleDateFormat, but I doubt that will buy us
much...

-- 
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