Re: [libreoffice-users] LO Calc question...

2014-10-26 19:48 GMT+01:00 Andrew Sullivan <andrew.t.sullivan@gmail.com>:

> I have a simple spreadsheet in Calc - just a few columns fo data and a
> chart at the top of the page.  The data columns are quite long (hundreds of
> lines eventually) and I would like to fix the position of the chart at the
> top of the page and scroll down the data columns.
>
> Assuming this makes sense, is it possible???

​There is probably some quirk with this solution, but you can lock the
scrolling (using the adequate option in the Window menu, I don't have the
exact name as I don't have the UI in english).

If a chart is in the locked part, it will not scroll when the rest of the
spreadsheet is scrolled. So, if for example you have your data starting at
row 20, and the chart is above that, locking the scrolling at line 20 will
allow browsing the document while viewing the chart.

There is also other possibilities, like opening a new window on the same
document (again in the Window menu), or move the chart to a separate tab,
but that might or might not suit your needs.

-- 
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