[Bug 61494] New: Updating meta properties in xlsm/xlsx corrupted equation

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

[Bug 61494] New: Updating meta properties in xlsm/xlsx corrupted equation

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

            Bug ID: 61494
           Summary: Updating meta properties in xlsm/xlsx corrupted
                    equation
           Product: POI
           Version: 3.16-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: critical
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

If any Core or Custom property added to the xlsx or xlsm file, It will corrupt
part of the content (to ? replacing actual value) in the floating equation
textbox.

Please follow the attachment,
- right.jpg is the actual content
- wrong.jpg is the corrupted one

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

--- Comment #1 from azad <[hidden email]> ---
Created attachment 35299
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35299&action=edit
Actual Content

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

--- Comment #2 from azad <[hidden email]> ---
Created attachment 35301
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35301&action=edit
Corrupted Content

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

azad <[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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

azad <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

azad <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #3 from Dominik Stadler <[hidden email]> ---
Can you provide unit-tests/sample-code/sample-files which allows to reproduce
the problem? Without this it is not possible to see where the actual problem
is.

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

--- Comment #4 from azad <[hidden email]> ---
Created attachment 35339
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35339&action=edit
Source and example files

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

--- Comment #5 from azad <[hidden email]> ---
Hi Dominik,
Thanks for your concern.

I have attached those source and input/output files in a zip as attachment
here.

Please feel free to ask any question!

-a-

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

--- Comment #6 from azad <[hidden email]> ---
Hi Dominik,
I was just wondering if you could use the source code and reproduce the broken
output file?

Thanks again!
-a-

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Depends on|                            |59268, 54084
         Resolution|---                         |DUPLICATE

--- Comment #7 from Dominik Stadler <[hidden email]> ---
FYI, for me this also happens when not adding any property at all, just reading
and writing the XLSX suffices. Very likely this is a duplicate of bug 54084,
which itself depends on a fix in the XMLBeans library, see bug 59268 all the
details.

There is an updated test-version of the XMLBeans library available at
http://mvnrepository.com/artifact/com.github.pjfanning/xmlbeans/2.6.2, using
this one makes this work for me, independent of writing custom/core properties
or not. So you might be able to use this library instead of xmlbeans-2.6.0.jar.

So this bug is a duplicate and will be fixed when we can get an updated version
of XMLBeans made available officially.

*** This bug has been marked as a duplicate of bug 59268 ***


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=54084
[Bug 54084] Some Unicode chars(e.g chinese chars) are not written corectly in
xlsx file.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59268
[Bug 59268] Work on providing an updated version of XMLBeans
--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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=61494
Bug 61494 depends on bug 54084, which changed state.

Bug 54084 Summary: Some Unicode chars(e.g chinese chars) are not written corectly in xlsx file.
https://bz.apache.org/bugzilla/show_bug.cgi?id=54084

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

--
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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

--- Comment #8 from azad <[hidden email]> ---
Thanks, it works with xmlbeans-2.6.2

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