[Bug 62629] New: Reaching a Rule M2.4 exception when trying to merge two files

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

[Bug 62629] New: Reaching a Rule M2.4 exception when trying to merge two files

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

            Bug ID: 62629
           Summary: Reaching a Rule M2.4 exception when trying to merge
                    two files
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Created attachment 36093
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36093&action=edit
Stacktrace

Hello,

I have a piece of code that I use to merge one excel sheet into a target
Workbook. The code used is pretty much coming from the following resource:
www.coderanch.com/t/420958/open-source/Copying-sheet-excel-file-excel.

While merging, an error is thrown by POI ContentTypeManage at:

if (this.container != null && this.container.getPart(partName) != null) {
                        throw new OpenXML4JRuntimeException(
                                        "Rule M2.4 exception : this error
should NEVER happen! If you can provide the triggering file, then please raise
a bug at https://bz.apache.org/bugzilla/enter_bug.cgi?product=POI and attach
the file that triggers it, thanks!");
                }

I tried to downsize the excel files used in my case, and I end up with the
files attached:

- targetWorkbook.xlsm which will receive the copy of the sheet. This workbook
contains a button (no macro attached anymore) and a picture.
- sheetToMerge.xlsx which contains the data to be copied in the target
Workbook. This sheet at the time being contains only one picture.

Now, the code will work under any of the following conditions:

- Remove the button from the targetWorkbook
- Remove the image from the targetWorkbook
- Remove the image from the sheetToMerge

I have dug a bit in the code, and also checked the [Content_Types].xml files
for all these workbooks, with no luck till now.

I attach the stacktrace, the code, and 2 files triggering the error.

PS: I am aware of the bug 62522; but I have reduced the files and the test case
used to trigger the bug, and i believe that the premise of the bug opening was
wrong. This bug is not solved if, i/o a jpg and a jpeg, I have two jpg, or two
jpeg. Plus, the error is not triggered if the button is removed, but still we
have both jpg and jpeg.

--
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 62629] Reaching a Rule M2.4 exception when trying to merge two files

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

--- Comment #1 from Lucas <[hidden email]> ---
Created attachment 36094
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36094&action=edit
The java class used for merging the 2 workbook

--
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 62629] Reaching a Rule M2.4 exception when trying to merge two files

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

--- Comment #2 from Lucas <[hidden email]> ---
Created attachment 36095
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36095&action=edit
The sheet to merge to trigger error

--
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 62629] Reaching a Rule M2.4 exception when trying to merge two files

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

--- Comment #3 from Lucas <[hidden email]> ---
Created attachment 36096
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36096&action=edit
The target workbook to trigger the error

--
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 62629] Reaching a Rule M2.4 exception when trying to merge two files

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

Dominik Stadler <[hidden email]> changed:

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

--- Comment #4 from Dominik Stadler <[hidden email]> ---
The problem is in the two source files, one has default content-type for
extension "jpg", the other for "jpeg".

It seems the application which produces these files is not creating fully
standard-conforming files.

one file:
<Default Extension="jpeg" ContentType="image/jpeg"/>

other file:
<Default Extension="jpg" ContentType="image/jpeg"/>

We now gracefully handle such situations with r1849814, but such files might
cause other issues in LibreOffice or Excel.

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