[Libreoffice-bugs] [Bug 128818] New: white boxes appear after saving an xlsx file with special comments

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128818

            Bug ID: 128818
           Summary: white boxes appear after saving an xlsx file with
                    special comments
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gtb11402 at eveav.com

Description:
We work exclusively on LibreOffice, but our partners regularly send us
xlsx-files for co-working. From time to time we receive files that are
displayed correctly in LO, but after saving in xlsx-format (and restarting
LibreOffice) they are overlaid by many white boxes. These boxes are then also
visible again in Excel.

We have now analyzed a file with Excel 2010 in more detail and found that the
problems are caused by a special form of comment. These comments behave in
Excel like text boxes (e.g. are transparent and rotatable). Before saving there
are about 80 drawing elements with the name "_x000_t202" and about 30 with the
name "AutoShape (and a number between 20 and 29)“ in LibreOffice-Navigator.
After saving in LO all elements are called "custom shapes" and the "AutoShape"
elements seem to be these white boxes, which could also be deleted.

We were able to reproduce the problem under Windows and Linux and analyzed it
for the first time with LibreOffice 6.1.5.2. However, we had the same behavior
with version 6.4 Alpha1. Similar descriptions exist on the Internet, but so far
without a bug report
(https://ask.libreoffice.org/en/question/19176/infinite-white-boxes/,
https://ask.libreoffice.org/de/question/204672/wie-kriege-ich-dieses-weisse-blatt-wieder-weg/,
https://ask.libreoffice.org/en/question/76644/white-box-covering-all-my-excel-worksheet/).

We have reduced a file to the relevant behavior and can make it available next
to two screenshots!

Steps to Reproduce:
1. opening the xlsx-file
2. save the file as xlsx again
3. restart LibreOffice and load the saved file

Actual Results:
white boxes appear

Expected Results:
no white boxes and no illegal drawing elements in the LibreOffice-Navigator


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191115/9ccd3693/attachment.html>