Thanks for that - I'll just move the chart! On 31 October 2014 21:16, Mark Bourne < libreoffice-ml.mbou...@spamgourmet.com> wrote:
> 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.sulli...@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 <joeconner2...@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+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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