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.
OOo should be the same as Excel or 1-2-3, for that matter: $C$5 -- John W. Kennedy "But now is a new thing which is very old-- that the rich make themselves richer and not poorer, which is the true Gospel, for the poor's sake." -- Charles Williams. "Judgement at Chelmsford" --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
