I think freeze and split windows are intended for scrolling around large
table of data, for example to keep heading and total rows and columns in
view. So they keep the rows in the views next to each lined up so the
headings match the data. But as I understand it, you want to break that
coupling, so you can scroll the left side up and down without the right
side moving. I don't think that's possible, although it may be an
interesting feature request. As it happens, I have a similar sheet where
I'm continually adding new data to the bottom of the table and have a chart
to the right of it, but I just move the chart down the sheet as more data
is added.
Another possibility is use Window > New Window to open a second window of
the same document, then arrange the two windows on screen as you want.
Changes in one window are reflected in the other (it's the same document,
not a copy). But I don't think that arrangement is saved so you'd have to
set the windows up each time you open the file, which may or may not work
for you. It may be possible to use a macro to automate opening a second
window and positioning it, but I'm not sure of the details for that and may
not work too well if someone with a different size screen opens it.
A couple of things which I don't think are quite what you want, but
mention in case they do the trick or inspire other ideas...
Place the cursor in F1 before selecting Window > Split or Window > Freeze.
But the two halves would scroll together vertically; you'll only be able to
scroll them separately horizontally.
You can also split both horizontally and vertically at the same time by
first positioning the cursor somewhere in the middle of the sheet (e.g.
F20) then Window > Split. But again the two parts next to each other
horizontally would be kept in sync when scrolling vertically, and the two
parts stacked vertically would be kept in sync when scrolling horizontally.
So you'd end up with only the lower left part available for scrolling
around your data. If you scrolled the top left part vertically, or the
lower right part horizontally, it would also scroll your chart in the top
right out of view. (Hope that all makes sense... if not just try it and see
what happens!)
Mark.
Andrew Sullivan wrote:
Is it possible to freeze the left and right parts of a spreadsheet (as
opposed to the upper and lower parts, which I know you can do)?
Thanks
Andrew
On 26 October 2014 20:06, Andrew Sullivan <andrew.t.sullivan@gmail.com>
wrote:
That doesn't do exactly what I want...
The data starts at A1; the chart occupies the space G3/M19. What I'd
ideally like to do is split the sheet vertically between say columns E
and
F and be able to scroll the data columns. Can this be done?
Thanks again.
Andrew
On 26 October 2014 19:21, Joe Conner <joeconner2007@gmail.com> wrote:
You are able. Select a cell below your chart, then
select WINDOW -> FREEZE.
That should do it.
Blessings, Joe Conner, Poulsbo, WA USA
On 10/26/2014 11:48 AM, Andrew Sullivan wrote:
Hello
First post here, hope it's in the right place...
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???
TIA
Andrew
--
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
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.