At 17:25 15/03/2014 +0100, Lorenzo Noname wrote:
a spreadsheet has thousands of lines and hundreds of columns. Most users (like me) don't need
that many cells. Is there any way to limit the amount of lines and rows in a specific file?
As has been suggested, there is usually no overhead in having so many rows and columns. Until
they are used, they exist only in the screen display and are not (explicitly) saved in the
document file.
At 20:29 15/03/2014 +0100, Lorenzo Noname wrote:
It is actually an usability improvement I'm after. If you are using a mouse with an inertial
scrolling (such as an Apple mouse or trackpad) and you want to get to the end of your sheet,
you can do a strong stroke with your finger. Problem is, you don't get to the end of your used
field, most of the time you end up in the middle of nowhere among unused cells…. It would be
nice to limit the size of your sheet then…
Someone has already beaten me to the suggestion of Ctrl+End, which moves to the last occupied
cell.
Another idea is to hide the rows and columns beyond those you are using; this is easily done
using Format | Row > | Hide and Format | Column > | Hide. Ctrl+down-arrow and Ctrl+right-arrow
usually move to the last row and column respectively, but will move to the last unhidden row
and column if you have hidden the rest. I hope (and believe) that you will find that your
mouse action is also limited to the unhidden region of your sheet.