Ask Your Question

XLSX Spreadsheet - Custom Shape problem

asked 2020-01-20 01:27:43 +0100

BamaFan gravatar image

updated 2020-08-02 02:43:59 +0100

Alex Kemp gravatar image

I have somehow unintentionally inserted a custom shape into my spreadsheet. This thing is almost completely obscuring the first 26 rows of my spreadsheet. My data is still there, I just can't see it or use it. How do I get rid this thing? Is this a bug in Libre spreadsheet?


(edit: activated screenshot)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-01-20 08:23:12 +0100

ebot gravatar image

updated 2020-01-21 06:06:15 +0100

It usually works like this: When the shape is selected, just press the DELETE button.

Please Note: "Recommendation for a clean working with LibreOffice when different office programs are used" see there last paragraph.

edit flag offensive delete link more


That's an excellent recommendation, I do recommend as well to save always at the native format of LO and then save as... Only if compatibility is needed for other people who will receive the document (i recommend to download LO, though)

ProLogic gravatar imageProLogic ( 2020-01-21 04:28:50 +0100 )edit

answered 2020-01-21 13:16:35 +0100

BamaFan gravatar image

I have solved my problem. I had actually inserted four of these things, each on top of the previous one. How? I have no idea, but it happened when I was scrolling using the mouse wheel. But I found that I could select and delete them. Thanks for your help. Parenthetically, the robot preventer on this page is so annoying. I know it is necessary, but why two iterations of it?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-20 01:27:43 +0100

Seen: 95 times

Last updated: Aug 02