Unable to get rid of custom shape

[ravi48]

Libre Office Version: 7.3.4.2 in Windows 10

In my LibreOffice Calc spreadsheet, there is a very prominent rectangle
which I would like to get rid off.

In ‘Normal’ mode, when I select it, the tool bar icons displayed changes to

When I select the rectangle and choose ‘Cut’, it does not disappear.
Also, unsuccessful in getting rid of it by going to ‘Page Break’ mode
and resizing the rectangle. Resize seems to work in ‘Page Break’, but the
original rectangle does not disappear.

Also, unsuccessful in getting rid of this rectangle through
Front / Print Ranges / Clear
Front / Print Ranges / Edit
Front / Print Ranges / Define

When the spreadsheet is printed, the rectangle does not get printed.
It is an eyesore when viewing the spreadsheet.

Relevant spreadsheet:
custom_shape_rectangle.xlsx (8.7 KB)

[dscheikey]

Could you upload a copy of your worksheet with deleted data here. As long as your rectangle remains, you could take a closer look and hopefully give you the decisive tip.

[ravi48]

Relevant spreadsheet without data that contains the rectangle uploaded as
custom_shape_rectangle.xlsx
in the edited ticket.

[dscheikey]

Hello! This could be cleared up quite quickly. If you open the side view and look at the drawing objects, you will see that your rectangle lies 48 times on top of each other.

So you have to delete all 48 objects, then the rectangle is finally gone.

This probably happened when copying the worksheets.

[Lupp]

Sorry, @dscheikey. Editing my answer crossed yours.

[ravi48]

For some reason in the side view, highlighting ‘CustomShape 1’ and hitting the delete key
does not get rid of selected instance of ‘CustomShape 1’. To delete an instance of ‘CustomShape 1’,
I have to select it using mouse in the spreadsheet and hit the Ctrl+X key to get rid of it. I was expecting
the delete to key to work from the side view.

[LeroyG]

@ravi48

hit the Ctrl+X

Or just the Delete key.

[dscheikey]

You can select the rectangles by double-clicking in the sidebar and then delete the rectangle with the Delete key.

[Lupp]

As I had supposed:

1. It was MS lumber.
2. There were nearly 50 instances of the rectangle (congruent shapes) inserted to the same position.

There is also a merged range.