[Solved] Constants in formulas
[Solved] Constants in formulas
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
Last edited by Hagar Delest on Tue May 21, 2019 9:30 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
NeoOffice Version: 2017.3 Professional Edition with MacOS 10.13.6
Re: constants in formulas
I have never used NewOffice but every other spreadsheet I have used uses the $ before both the column and row.
Code: Select all
=$C$12
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Constants in formulas
You might find [Tutorial] Absolute, relative and mixed references useful reading.
Also, see if there is more information on the NeoOffice resources site
Also, see if there is more information on the NeoOffice resources site
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: Constants in formulas
Thank you!
NeoOffice Version: 2017.3 Professional Edition with MacOS 10.13.6