[Solved] Constants in formulas

Discuss the spreadsheet application
Post Reply
nolac
Posts: 2
Joined: Sat May 18, 2019 6:44 pm

[Solved] Constants in formulas

Post by nolac »

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
NeoOffice Version: 2017.3 Professional Edition with MacOS 10.13.6
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: constants in formulas

Post by FJCC »

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.
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Constants in formulas

Post by robleyd »

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

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
nolac
Posts: 2
Joined: Sat May 18, 2019 6:44 pm

Re: Constants in formulas

Post by nolac »

Thank you!
NeoOffice Version: 2017.3 Professional Edition with MacOS 10.13.6
Post Reply