Hi Brent,
If you enter =$c5 in excel and fill down, you'll get =$c6,
=$c7, =$c8 .... You'll get the same thing in calc. If you
want and absolute address for both row and column, you have
to enter =$c$5.
tc
Brent Opsahl wrote:
I have been trying to figure out how to lock a formula to one cell. it is the
function you use in excle that goes like this $C5* A6, and then when you fill
the formula down it stays on C5 when you go to A7 and so on for as long as you
want to go. and in OpenOffice calc i can't seem to get this to work.
Have a great day
Brent
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
