Apache OpenOffice Community Forum

I am trying to copy and paste formulas in my spreadsheet to other cells. The software adds rows to the original cell locations in the original formula; I would like it to keep the original cell locations. In Excel if I remember correctly, you simply put a '$' before the cell number to achieve this. Can anyone tell me please what the solution is in NeoOffice? Thank you

I have never used NewOffice but every other spreadsheet I have used uses the $ before both the column and row.

You might find [Tutorial] Absolute, relative and mixed references useful reading.

Also, see if there is more information on the NeoOffice resources site

Thank you!