[Libreoffice-bugs] [Bug 117287] New: FILESAVE XLSX: Comments always disappear after opening the exported XLSX file with Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117287
           Summary: FILESAVE XLSX: Comments always disappear after opening
                    the exported XLSX file with Excel
           Product: LibreOffice
           Version: 6.1.0.0.alpha1+ 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 141704
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141704&action=edit
Example file from Excel 2010

If we export an *.xlsx file, which contains a comment, with LibreOffice Calc
and open with Microsoft Excel 2010/2013/2016 the comment will be hidden after
we click on the commented cell.

Steps to reproduce:
1. Create a new XLSX file in Microsoft Excel 2010/2013/2016
2. Add a comment to a cell.
3. Set the comments visibility to “Show all comments”
4. Save the file as *.xlsx.
5. Open the file with LibreOffice Calc and save as *.xlsx
6. Open the file with Microsoft Excel and click on the commented cell. (the
comment will disappear)


Actual results:
After we open the exported file with Microsoft Excel and click on the commented
cell the comment will be hidden. Despite we set the comments visibility setting
to “Show all comments”.
The problem may be related to the “vmlDrawing1”.vml file, because after the
LibreOffice Calc export the <x:Visible/> tag disappeared from the
“vmlDrawing1.vml” file.
If we reopen the ORIGINAL file with Microsoft Excel, the comment will not
disappear if we click on the commented cell.

Expected results:
The comments should not be hidden after we reopen the exported *.xlsx file with
Microsoft Excel.


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/0355ba82/attachment.html>