[Bug 64450] New: InvalidFormatException because of a PivotTable

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64450] New: InvalidFormatException because of a PivotTable

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450

            Bug ID: 64450
           Summary: InvalidFormatException because of a PivotTable
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: PC
            Status: NEW
          Severity: regression
          Priority: P2
         Component: OPC
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Created attachment 37250
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37250&action=edit
XLSX File to reproduce the issue

Reading an XLSX document exported from Google Sheets raises an
org.apache.poi.openxml4j.exceptions.InvalidFormatException: invalid
relationship part/id when the excel file contains a PivotTable.

Code:
OPCPackage.open(stream)

Exception trace:
org.apache.poi.openxml4j.exceptions.InvalidFormatException: invalid
relationship part/id
        at
org.apache.poi.openxml4j.opc.PackageRelationshipCollection.parseRelationshipsPart(PackageRelationshipCollection.java:358)
~[poi-ooxml-4.1.2.jar:4.1.2]
        at
org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:163)
~[poi-ooxml-4.1.2.jar:4.1.2]
        at
org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:133)
~[poi-ooxml-4.1.2.jar:4.1.2]
        at
org.apache.poi.openxml4j.opc.PackagePart.loadRelationships(PackagePart.java:570)
~[poi-ooxml-4.1.2.jar:4.1.2]
        at
org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:734)
~[poi-ooxml-4.1.2.jar:4.1.2]
        at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:310)
~[poi-ooxml-4.1.2.jar:4.1.2]


POI version 3.17 was able to read the file with no issues.

Find attached an example.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64450] InvalidFormatException because of a PivotTable

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450

odelpozo <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
                 OS|                            |All

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64450] InvalidFormatException because of a PivotTable

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450

Matafagafo <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64450] InvalidFormatException because of a PivotTable

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450

Dominik Stadler <[hidden email]> changed:

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

--- Comment #1 from Dominik Stadler <[hidden email]> ---
A change via r1885056 allows to parse such a document. However it seems this
file is slightly corrupt as it includes an empty id in the relationship
definitions.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64450] InvalidFormatException because of a PivotTable

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450

--- Comment #2 from odelpozo <[hidden email]> ---
(In reply to Dominik Stadler from comment #1)
> A change via r1885056 allows to parse such a document. However it seems this
> file is slightly corrupt as it includes an empty id in the relationship
> definitions.

Hello,

Thanks for the update. When is expected to be released the version of the
library with this issue fixed?

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64450] InvalidFormatException because of a PivotTable

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450

--- Comment #3 from Dominik Stadler <[hidden email]> ---
It will be included in the next major release 5.0.0 which is currently in the
"voting phase", so ideally will be available soon.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]