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 2017/09/06 11:32:31 UTC

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

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: dev@poi.apache.org
          Reporter: ak.azad@gmail.com
  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

--- Comment #2 from azad <ak...@gmail.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

azad <ak...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |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 61494] Updating meta properties in xlsm/xlsx corrupted equation

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

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

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

--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

azad <ak...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ak.azad@gmail.com

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

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

azad <ak...@gmail.com> changed:

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

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61494
Bug 61494 depends on bug 59268, which changed state.

Bug 59268 Summary: Work on providing an updated version of XMLBeans
https://bz.apache.org/bugzilla/show_bug.cgi?id=59268

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

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

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

--- Comment #6 from azad <ak...@gmail.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

--- Comment #1 from azad <ak...@gmail.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

--- Comment #8 from azad <ak...@gmail.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

--- Comment #5 from azad <ak...@gmail.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

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

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

--- Comment #7 from Dominik Stadler <do...@gmx.at> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

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

--- Comment #4 from azad <ak...@gmail.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org