LO Calc question...

users
#1

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

#2

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

#3

Hello Andrew,

Assuming this makes sense, is it possible???

If I understand you correctly, you want the first few rows fixed in
place so they don't scroll of the top of the screen.

To do that, select the column A of row _below_ the last one you want
fixed in place, and from the _W_indow menu, choose "Freeze".

#4

Sorry, this should have gone to all…

#5

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:

#6

Thanks for that - I'll just move the chart!