Description: It never made sense to have a spreadsheet program starts with so many rows and columns. It is so annoying and counter-productive. This is like launching a drawing application to have 10,000x10,000 pixel canvas, or like entering a text editor to see 10,000 empty lines. Why not just let the user pick the suitable size? Steps to Reproduce: 1. Select rows 2. Go to: Sheets > Delete Rows Actual Results: Rows are only shifted not deleted. There are still 1048576 rows in the application. Expected Results: Rows should be reduced Reproducible: Always User Profile Reset: No Additional Info: See this screenshot for the desired result: https://i.imgur.com/rRwlq2M.png Make users choose the size of they need. This has been requested many times in Discourse: * https://ask.libreoffice.org/t/17888 * https://ask.libreoffice.org/t/86321 * https://ask.libreoffice.org/t/85718
Only up to the last row/column used, they truly exist. You can hide the row/columns you don't want to see. *** This bug has been marked as a duplicate of bug 80700 ***