Hi
Good plan!
I was wondering if another way might be to use the freeze window to keep
the left side steady and then do the "split" on the right. I tend to find
the "split" thing gets VERY confusing because people seem to be able to
scroll all different ways inside all 4 quadrants. Better to just open the
same file 2-4 time imo. The freeze option keeps it's 4 quadrants lined-up
with each other other and looks very tidy and professional.
Errr, i just tried it and you can't use split and freeze at the same time.
Split looked a LOT less confusing than when i last used it (in the previous
millenium (so i guess some things have moved on since then!)).
So my next thought was whether the spreadsheet could be viewed in html,
maybe with frames (yuk!) or something?
Also wondering if Gnumeric could view the spreadsheet in such a way?
It might be an interesting "feature request". I can't imagine many people
needing it but it might still be interesting. I wonder if it could be
added as an "Extension". That made me wonder if someone already has
created an Extension to do this. There are a few Extensions that greatly
add to Calc's functionality so i wonder if any of them do this already.
Personally i would rather see Calc gain the ability to have a chart be an
entire sheet rather than having to try to put a chart on top of a sheet
(and maybe some weeu scrolling too far and 'lose' the chart).
On the other hand Andrew seems happy to do what most of us do and just move
the chart so this thread is really closed now isn't it?
Regards from
Tom