Way to mark a calc cell as "constant" in a formula so that it is not shifted on copy/paste?

[JacquesGuddebuer]

I have a simple problem in calc for which a solution must exist already:

1. I have a cell that contains a (constant) parameter
2. Other cells compute a value based on said parameter and the contents of other cells
3. If I copy-paste the “computing cells” then
   • The references are “vector-translated” to match the position of the pasted-to cell, which is what one wants
   • The “parameter” reference is also “vector-translated”, which is absolutely NOT what one wants

Is there a way to mark a formula value as “do not vector-translate” (I’m dreaming of something simple like prepend the cell name with “!”)?

[anon73440385]

Hello,

your dreams come true, the character is $

You need to get familiar with absolute addressing using $ and relative addressing. Let’s assume your (constant) parameter cell is A1 then you need to use $A$1 (instead of A1) in each formula, which you don’t want to be translated (in your terms) on copying a cell containing the formula. There are also use cases, where you may want columns adapted but not rows (A$1) or rows adapted but not columns ($A1).

For more information see LibreOffice Help - Addressing

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.

[rt2258tw]

Yes, it did help.