Re: [libreoffice-users] Calc: limit number of columns and rows

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