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


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

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.