<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILESAVE XLSX: Comments always disappear after opening the exported XLSX file with Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117287">117287</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX: Comments always disappear after opening the exported XLSX file with Excel
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.0.alpha1+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=141704" name="attach_141704" title="Example file from Excel 2010">attachment 141704</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=141704&action=edit" title="Example file from Excel 2010">[details]</a></span>
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@42, Branch:master, Time: 2018-04-25_00:27:22
Locale: hu-HU (hu_HU); Calc: group</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>