If I select a number of items (as I do in Excel) LibreOffice only wants to delete these cells.
I would prefer some solution that I can put on a toolbar which I currently do in Excel.
To delete a column in Calc, click on the column letter, and then right-click so that the pop-up menu appears. About half-way down is “Delete Selected Columns”. To delete multiple columns, click-and-drag in the column letter “area” so as to select multiple columns. Then right-click as before.
Same to delete rows, except you click on the row numbers.
Additional to the above answer, you can add icons to the “formatting toolbar” to be able to add or delete row or columns. From Tools - Customize - Toolbars - Formatting, you can add the commands you need.