<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 - EDITING : Delete all customshape at once"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132021">132021</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING : Delete all customshape at once
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.2.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>enhancement
</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>frederic@juliana-multimedia.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Hi,
When editing xlsx documents, there is sometimes a bug, which I believe comes
from Excel, which makes many customshape appear and overlap. It is a white
rectangle shape called "CustomShape 1".
There are many comments on this problem:
<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://stackoverflow.com/questions/39208861/delete-all-objects-with-a-specific-name">https://stackoverflow.com/questions/39208861/delete-all-objects-with-a-specific-name</a>
With Excel, there are several methods to remove these customshape in a few
manipulations as with the "Go To" box:
<a href="https://www.extendoffice.com/documents/excel/714-excel-delete-all-auto-shapes.html">https://www.extendoffice.com/documents/excel/714-excel-delete-all-auto-shapes.html</a>
When you have this file with LibreOffice Calc, you must delete the customshape
one by one by hand.
You can see these customshape in the browser (F5), but you cannot delete them.
It would be interesting to have the possibility in the browser (F5) to be able
to select them all, and delete them all at once.
Regards.
Steps to Reproduce:
Open a bugged xlsx file.
Actual Results:
Many customshape masks the spreadsheet.
Expected Results:
Select and delete customshape easily.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version : 6.4.2.2
Build ID : 1:6.4.2-3
Threads CPU : 8; OS : Linux 5.4; UI Render : par défaut; VCL: gtk3;
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded</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>