Date: Sun, 30 Nov 2003 18:01:24 +0100 From: Oliver Lehmann <lehmann@ans-netz.de> To: openoffice@freebsd.org Subject: static references in Openoffice (calc) Message-ID: <20031130180124.155f7029.lehmann@ans-netz.de>
next in thread | raw e-mail | index | archive | help
Hi,
the question isn't FreeBSD related, but OpenOffice related.
I have for example 3 Worksheets called "Jan 03", "Feb 03" and "Mar 03". On
"Feb 03" I have a formula with a reference to a field in "Jan 03". When I
now copy these Formula-field from the "Feb 03"-sheet to the "Mar 03" one
the reference changes from "Jan 03" to "Feb 03".
How to mark a reference static? In Word I had to put the static string
between $ (by pressing F4) iirc.
Greetings, Oliver
--
Oliver Lehmann
@home: lehmann@ans-netz.de
@office: oliver.lehmann@mgi.de
@www: http://www.pofo.de/ | http://wishlist.ans-netz.de/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20031130180124.155f7029.lehmann>