On 16-3-2014 10:18, Lore wrote:
Il giorno 15/mar/2014, alle ore 20:56, Brian Barker <[email protected]>
ha scritto:
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.
I trust this helps.
Brian Barker
> Brian,
> correct me if I’m wrong but it looks like hiding the unwanted cells
makes the scrolling really slow…
>
> Thanks
>
> Lorenzo
not it does not make thing slow, at least it does not in my test......
How many rows/columns are in your situation?
And how many cells have forumulas in them (which should not make a
difference...) ?
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
