floating spreadsheet cells

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: June Tate
Date:  
Subject: floating spreadsheet cells
--=-JO8tvUhK+clfXy9rrjfj
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Mon, 2004-01-12 at 01:50, der.hans wrote:
> Am 12. Jan, 2004 schw=E4tzte Michael so:
>=20
> > I do not think this is possible with out creating a seperate sheet for =

each
> > instance. I know this can be done in a database by creating sub-forms f=

or
> > each entry. I have not seen this done before in a spreadsheet.
>=20
> I know it can be done in a spreadsheet as I get them. I know both OO.o an=

d
> gnumeric can view them. I just don't know how to create them.
>=20
> ciao,
>=20
> der.hans


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.

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

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.

HTH. =3Do)

--=20
June Tate * <> * http://www.theonelab.com


--=-JO8tvUhK+clfXy9rrjfj
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBAAmi3e5i+GsTTlpkRAroEAKCHcizC3aTAR0w6m23SRPuLy+ImPACfTGCS
OvQQWYwPK+h6kI7IhqM6mH0=
=tKro
-----END PGP SIGNATURE-----

--=-JO8tvUhK+clfXy9rrjfj--