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: https://ask.libreoffice.org/en/question/19176/infinite-white-boxes/ https://stackoverflow.com/questions/39208861/delete-all-objects-with-a-specific-name With Excel, there are several methods to remove these customshape in a few manipulations as with the "Go To" box: https://www.extendoffice.com/documents/excel/714-excel-delete-all-auto-shapes.html 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
Created attachment 159467 [details] View of browser with lots of customshape
Created attachment 159468 [details] Stacked customshape mask content
Let's ask UX. Btw. during testing I was confused at first, because I didn't understand that you need to give a name to the shape before it will show up in the Navigator. I don't see a way in the Calc Navigator to display unnamed shapes.
Ah, pointless to ask: bug 107670 for Writer was already addressed.
(In reply to Buovjaga from comment #3) > Btw. during testing I was confused at first, because I didn't understand > that you need to give a name to the shape before it will show up in the > Navigator. I don't see a way in the Calc Navigator to display unnamed shapes. Created bug 134344 for this topic
For the automatic naming see bug 34828 comment 16 (I'm for automatic naming). * Per double-click it's possible to select an object; we should implement the delete function at the Navigator too, which makes single click possible. * And we need multi-selection in the Navigator, meaning if two or more objects are selected the corresponding entries in the Navigator should be selected too. At least it needs to be possible to multi-select items in the Navigator and apply some but not all function to these items (GoTo makes no sense- and is not listed in the context menu- but Delete does). Something for you, Jim? * Ultimately I wonder where the autoshapes come from and why they apparently are not placed correctly. The macro solution from ask.libo seems to be good for this actual issue.
(In reply to Buovjaga from comment #4) > bug 107670 ...is about sections in Writer.
Hello, I can reproduce this bug in LibreOffice Calc version 6.4.6.2 and 7.0.2.2 when opening an .xlsx file. After saving the file the next time opening the file, the white drawing objects are back (not always). Can you please fix this bug and not add this workaround?
Does anyone have a sample file for this bug?