New spreadsheets are created with a million row and hundreds of columns. But practically most time user don't need that many columns and rows. And having that many cells is an annoyance as the focus can accidentally go to far away where there is no data. Can you please provide an option to automatically hide most rows when user create a new spreadsheet. That is, something similar to entries at "Tools > Options... > LibreOffice Calc > Default > New Spreadsheet" See attachment 101994 [details]
@Markus - any thoughts on this enhancement request? Is it reasonably possible?
(In reply to Biju from comment #0) > Can you please provide an option to automatically hide most rows when user > create a new spreadsheet. > > That is, something similar to entries at > "Tools > Options... > LibreOffice Calc > Default > New Spreadsheet" > > See attachment 101994 [details] Thanks for the mock-up. The idea sounds plausible, so Status -> NEW. The Devs and UX can make further decisions.
I don't like the idea as a) it's not hard to go back when the cursor is at the very most bottom/right and b) setting some columns/rows back to visible isn't possible. I would abstain from this enhancement but we could ask the community.
Will most likely not be implemented from a developer perspective. I think it will just cause us more issues as it introduces additional (soft) spreadsheet borders. Handling of the existing borders is already difficult enough.
Closing this issue as WONTFIX based on c3 and c4
*** Bug 155802 has been marked as a duplicate of this bug. ***
Please reconsider this FR, again. (In reply to Heiko Tietze from comment #3) > I don't like the idea as a) it's not hard to go back when the cursor is at > the very most bottom/right and b) setting some columns/rows back to visible > isn't possible. I would abstain from this enhancement but we could ask the > community. A) Those extra cells are not needed in the first place. This is like having a text editor inserting 10,000 empty lines unnecessarily whenever a new file is opened. B) setting some columns/rows back to visible isn't possible. Yes. That's why the solution was never hiding them in the first place. Hiding != deleting. The solution is to make the action in `Sheet > Delete rows/columns` completely delete the rows or columns, not just clear its content and shift them. Make users choose the size of they need. This has been requested many times on forums: * https://ask.libreoffice.org/t/17888 * https://ask.libreoffice.org/t/86321 * https://ask.libreoffice.org/t/85718
Unlike at other spreadsheet tools (although it works the same in MS Excel) deleting a row or column means to add new one at the end. You can _hide_ row/cols and create a template with this virtually smaller size.