Brian, correct me if I’m wrong but it looks like hiding the unwanted cells makes the scrolling really slow…
Thanks Lorenzo 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 > > > -- > 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 > -- 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
