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