[Solved] Constants in formulas

Discuss the spreadsheet application

[Solved] Constants in formulas

Postby nolac » Sat May 18, 2019 6:51 pm

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

Re: constants in formulas

Postby FJCC » Sat May 18, 2019 7:56 pm

I have never used NewOffice but every other spreadsheet I have used uses the $ before both the column and row.
Code: Select all   Expand viewCollapse view
=$C$12
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7161
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Constants in formulas

Postby robleyd » Sun May 19, 2019 1:29 am

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
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2767
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Constants in formulas

Postby nolac » Tue May 21, 2019 1:01 am

Thank you!
NeoOffice Version: 2017.3 Professional Edition with MacOS 10.13.6
nolac
 
Posts: 2
Joined: Sat May 18, 2019 6:44 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 23 guests