<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Saving a XLSX in shared mode adds white rectangles covering top left part of the sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130255">bug 130255</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>DUPLICATE
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Saving a XLSX in shared mode adds white rectangles covering top left part of the sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130255#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Saving a XLSX in shared mode adds white rectangles covering top left part of the sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130255">bug 130255</a>
from <span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span></b>
<pre>This is because of the comment in B52, not the shared mode (which is lost on
save anyways -> <a class="bz_bug_link
bz_status_NEW "
title="NEW - Shared document status lost when saved as XLSX"
href="show_bug.cgi?id=100433">bug #100433</a>).
The Excel comments have text contents and a VML shape for positioning, and the
broken export of this VML shape was fixed in <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - FILESAVE XLSX: Drawing Objects (Shapes) multiply every time an XLSX file with comments roundtrips"
href="show_bug.cgi?id=117274">bug #117274</a>.
Excel considered the LO-saved VML broken, and saved it as a separate, but
virtually invisible shape (and created a new one for positioning the comment).
This is the "Autoshape 2" in the example file.
Another save in LO <= 6.3 made this shape visible that's how the huge white
rectangle was created.
If you double click in the Navigator on the "Autoshape 2" and press Del to
delete it, the problem will no longer occur in 6.4 after save & reload.
The fix to <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - FILESAVE XLSX: Drawing Objects (Shapes) multiply every time an XLSX file with comments roundtrips"
href="show_bug.cgi?id=117274">bug #117274</a> stopped creating broken VML files, but does not remove
the autoshapes stashed away by Excel - you can do that only manually.
*** This bug has been marked as a duplicate of <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - FILESAVE XLSX: Drawing Objects (Shapes) multiply every time an XLSX file with comments roundtrips"
href="show_bug.cgi?id=117274">bug 117274</a> ***</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>