Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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 <b.m.barker@btinternet.com> 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: users+unsubscribe@global.libreoffice.org
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: users+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.