I’d like to make a workbook stop at something small, like 65536, instead 1048576. It’s really annoying when I accidentally control-down from the last row I’m working on and cause my workbook to freeze up for minutes on end (if not outright crash).
Spreadsheets don’t create rows or columns. They are created with a logical range, and no unused cell is actually represented directly in RAM. No wasted space.
If you want to see less rows and/or columns, you need to hide the additional ones.
Select the bottom right cell of the range you want to see.
Now go one step right and one down,
Ctrl+Shift+RightArrow
Rightclick one highlighted column header ===> Hide Columns
Ctrl+Shift+DownArrow
Rightclick one highlighted row header ===> Hide Rows.
Done!
(IMO: No sense in all that.)
1 Like
Thanks for the suggestion, but I can’t even select those rows to hide without causing my sheets to freeze up…
A database table is created before you store any data. You define the columns of a database and the table has as many rows as there are stored records.
I think the actual issue is that Calc freezes when it shouldn’t have any problem. It is normally just a second or two for realisation that you have gone too far and pressing Ctrl+↑ to go back to last row.
You should see if the freeze occurs in Help > Restart in safe mode > Continue in Safe Mode.
Have a look at First steps to take before submitting a bug - The Document Foundation Wiki, one of the fixes might be a solution for the freeze.
1 Like