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

At 10:18 16/03/2014 +0100, Lorenzo Noname wrote:
> Il giorno 15/mar/2014, alle ore 20:56, Brian Barker 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.
>
> correct me if I'm wrong but it looks like hiding 
> the unwanted cells makes the scrolling really slow…

I don't find this problem.  Do others?  (I see 
already that one contributor doesn't.)  Is the 
behaviour you see perhaps unique to your particular scrolling technique?

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