I have a formula in *Libreoffice Calc* which I would like to move (Cut and Paste) to a different cell. I would like the formula to exactly stay the same without the cells in it being adjusted by the move. I cannot use static reference (using the *$* sign) since on a different occasion I need the dynamic reference behaviour.

The only solution I have found so far, is manually copying and pasting the *text* of the formula instead of the cell itself. But this only works for a single cell and not for multiple ones.