<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 - white boxes appear after saving an xlsx file with special comments"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128818">128818</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>white boxes appear after saving an xlsx file with special comments
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.5.2 release
</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>gtb11402@eveav.com
</td>
</tr></table>
<p>
<div>
<pre>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
(<a href="https://ask.libreoffice.org/en/question/19176/infinite-white-boxes/">https://ask.libreoffice.org/en/question/19176/infinite-white-boxes/</a>,
<a href="https://ask.libreoffice.org/de/question/204672/wie-kriege-ich-dieses-weisse-blatt-wieder-weg/">https://ask.libreoffice.org/de/question/204672/wie-kriege-ich-dieses-weisse-blatt-wieder-weg/</a>,
<a href="https://ask.libreoffice.org/en/question/76644/white-box-covering-all-my-excel-worksheet/">https://ask.libreoffice.org/en/question/76644/white-box-covering-all-my-excel-worksheet/</a>).
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:</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>