You can also use Cut and Paste instead of Copy and Paste.
If you also want to keep the original first Copy and Paste to a temporary space. Then Copy and Paste back from here after the above.
Hello,
use absolute addressing ($A$1 instead of A1) in your formulas - see LibreOffice Help - Addresses and References, Absolute and Relative
Hope that helps.
If the answer helped to solve your problem, please click the check mark (✔) next to the answer.
Asked: 2020-05-09 22:26:09 +0100
Seen: 94 times
Last updated: May 11 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Please change tags!
donseems to be your name and has nothing to do with LO.Apparently, your question is not related to the formula editor Math but to the spreadsheet app Calc. In this case, the correct tag is
calc.Question retagged for site consistency. If you disagree, and also to give a more appropriate tag, use the retag link under your question.