floating spreadsheet cells

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: der.hans
Date:  
Subject: floating spreadsheet cells
Am 12. Jan, 2004 schw=E4tzte June Tate so:

> Gnumeric's interface has View -> Freeze that freezes the "top left" of
> the spreadsheet, but I can't figure out how to shift it to one
> set of columns or rows right now.


Translations are so much fun. "Fl=E4chen einfrieren" is "freeze area" and
"Fl=E4chen auftauen" is "defrost area" :).

> In OOo, however, there are two methods to doing this. One is to split
> the window by selecting the range you want, and selecting Window ->
> Split from the menu. This will cause the spreadsheet to be split into
> two independently scrollable areas (also doable via the horizontal and
> vertical black bars near the scrollbars).


You can scroll back to the other view, though, so that's not what I want.

> The other, more traditional way, is to select the range you want to
> freeze (at least one row or column larger than the actual set you want
> frozen) and selecting Window -> Freeze from the menu.


OK, this looks like what they're using. It also looks like OO.o and gnumeri=
c
can display things that they can't setup. The xls file I have has row 1
frozen, but nothing else. Haven't been able to get OO.o or gnumeric to do
that.

Now I know where to look, though, so mucho thankos!

ciao,

der.hans
--=20
#  https://www.LuftHans.com/    http://www.AZOTO.org/
#  "The purpose of IT is to seamlessly and transparently provide the other
#  9/10's of the iceberg for people who need to work with chunks
#  of floating ice." -- Strata Rose Chalup