--=-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--