[Libreoffice-bugs] [Bug 117274] New: FILESAVE XLSX: Drawing Objects (Shapes) multiply every time an XLSX file with comments roundtrips

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117274
           Summary: FILESAVE XLSX: Drawing Objects (Shapes) multiply every
                    time an XLSX file with comments roundtrips
           Product: LibreOffice
           Version: 6.1.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 141676
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141676&action=edit
Example file from Excel 2010

Drawing Objects/shapes from the comments object multiply every time, when an
XLSX file with comments is saved in LibreOffice Calc. The bug only occurs if
the file was saved in LibreOffice Calc, then in Microsoft Excel and then
open/saved in LibreOffice Calc again.
It does not matter however, if it was originally created in LibreOffice Calc or
Microsoft Excel, whether the comments were added in Calc or Excel.

Steps to reproduce:
1. Create a new XLSX file in Microsoft Excel 2010/2013/216 and add a comment to
a cell. Save the file.
2. Open the file with LibreOffice Calc (turn on the Navigator, just see what is
happening), add a comment to another cell and save as *.XLSX
3. Open the file with Microsoft Excel and add a comment to a cell, and save as
*.XLSX
4. Open the file with LibreOffice Calc and watch the navigator: there will be
two Drawing Objects, but we cannot see them in the spreadsheet. We only see if
we want to print the spreadsheet. (Print Preview)
5. Save the file as *.XLSX and reload the file: the original Drawing Objects
name will appear as “CustomShape1”.
6. If we open this file with Microsoft Excel and save again, and then
import/export with LibreOffice Calc: the Drawing Objects multiply again.

Actual results:
Every time we open and save an *.xlsx file with LibreOffice Calc, which was
saved earlier with Microsoft Excel and contains comments, the Drawing Objects
will be duplicated and we cannot print normally the spreadsheet, only if we
turn off the Drawing Objects print checkbox.

We tried to look into the generated XLSX files. We see that for each comment a
new drawing object is created into xl/drawings/vmlDrawing1.vml. 
This file when saved/created in Calc is considered broken by Excel, then the
object contained in it is moved into xl/drawings/drawing1.xml and a new
vmlDrawing1.vml is created. 
Again opening and saving the file in Calc, this vmlDrawing1.vml file gets
broken again, and Excel adds its content to drawing1.xml and creates a new
vmlDrawing1.vml.

Expected results:
There should no drawing object appear in the Navigator after we open a
spreadsheet with comments.


Version: 6.1.0.0.alpha0+
Build ID: aa45e2745f14c5626fe163939dc7d101efe9d1cd
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86 at 42, Branch:master, Time: 2018-04-25_00:27:22
Locale: hu-HU (hu_HU); Calc: group

-- 
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/20180427/377545f6/attachment.html>