[SOLVED] libreoffice calc variable defining

nTia89 · 2014-07-20 16:34:28

Hi to everybody,
I need to define a variable/constant in Excel / libreoffice calc.
E.g.:
I need the universal gas constant R=8.1345
And I must use it in many formulas such as =A1*B2*8.3145*(C3-D4)
Now, does exist any way to store the constant in a variable and use it in the formulas in this way: =A1*B2*r*(C3-D4)
Saving my time !!!

Thank you

Last edited by nTia89 (2014-07-20 17:34:59)

ewaller · 2014-07-20 16:41:14

You can force an absolute reference to a cell as opposed to a relative reference by using a $ in front of the row or column. If you put the value of R in a Cell, say A123, refer to that cell in your equations as $A$123. When you copy formulae that contain that form and paste them elsewhere, references that use the $form are not updated based on the relative location to where the formula is pasted. It would take the form:

A1*B2*$A$123*(C3-D4)

nTia89 · 2014-07-20 16:47:30

ewaller wrote:

You can force an absolute reference to a cell as opposed to a relative reference by using a $ in front of the row or column. If you put the value of R in a Cell, say A123, refer to that cell in your equations as $A$123. When you copy formulae that contain that form and paste them elsewhere, references that use the $form are not updated based on the relative location to where the formula is pasted. It would take the form:
A1*B2*$A$123*(C3-D4)

I understand what do you mean, but this is not what I need!

graysky · 2014-07-20 16:54:50

It's exactly what you need. Store the constant in a cell of your choosing and reference that cell in your calculations.

nTia89 · 2014-07-20 16:59:00

No, in this way I simply use the cell reference...

graysky · 2014-07-20 17:01:09

Yes... How is that not what you asked to have?

nTia89 · 2014-07-20 17:04:55

I need this:
cell with inside

=r

should shows

8.3145

I'd get the same result with

=$A$123

BUT it's not what I want

graysky · 2014-07-20 17:07:00

You'll have to type several characters rather than one, but it allows you to redefine the variable.

ewaller · 2014-07-20 17:12:06

Perhaps this

Anyway, as this thread has nothing do with Arch, and the link I provided is applicable to Excel, which only runs on proprietary operating systems, I am going to put on my moderator's cap and close and bin this thread IAW https://wiki.archlinux.org/index.php/Fo … pport_ONLY

nTia89 · 2014-07-20 17:12:13

OK, but this is only a "workaround"...

I know this is possible because I have an xls with that

ewaller · 2014-07-20 17:27:27

I read your report to the moderators and have reconsidered my position. I have reopened the thread and have moved it to Applications and Desktop Environments. I do ask that you change the thread title to reflect software that is available in our repositories.

nTia89 · 2014-07-20 17:39:16

Solved!

You can define a variable with the name manager, the other input field on the left of the input field formula.

There are many options but basically you need to choice a name (with some restriction) and select the cell...

Arch Linux

#1 2014-07-20 16:34:28

[SOLVED] libreoffice calc variable defining

#2 2014-07-20 16:41:14

Re: [SOLVED] libreoffice calc variable defining

#3 2014-07-20 16:47:30

Re: [SOLVED] libreoffice calc variable defining

#4 2014-07-20 16:54:50

Re: [SOLVED] libreoffice calc variable defining

#5 2014-07-20 16:59:00

Re: [SOLVED] libreoffice calc variable defining

#6 2014-07-20 17:01:09

Re: [SOLVED] libreoffice calc variable defining

#7 2014-07-20 17:04:55

Re: [SOLVED] libreoffice calc variable defining

#8 2014-07-20 17:07:00

Re: [SOLVED] libreoffice calc variable defining

#9 2014-07-20 17:12:06

Re: [SOLVED] libreoffice calc variable defining

#10 2014-07-20 17:12:13

Re: [SOLVED] libreoffice calc variable defining

#11 2014-07-20 17:27:27

Re: [SOLVED] libreoffice calc variable defining

#12 2014-07-20 17:39:16

Re: [SOLVED] libreoffice calc variable defining

Board footer