How to copy paste without data (functions) changing : calc

When I copy (Data:Column - Rows) and paste right below prior data why do all my functions change.

How do I prevent this from happening.

Some functions I’m able to put “$” and it will keep the function (command) but I cannot do this for all functions (=sum( ))

How do I copy / paste without any data changing within the copied cells when I paste to a new row.

Purpose: trying to see overall data and sorted data in the same document.

thank you in advance for any help anyone provides.

Could you post example of functions that change in the way you do not want them to, if possible show the before copy, after copy and how you would prefer it after the copy.

I figured out the problem: I needed to Paste Special, then use folder at top says Values & Format
everything worked perfect
really impressed with LO with all the functions / capabilities

------ i spoke to soon, it only copies Values (numbers) not the function =sum() or Rank or Index,Match function
-------- frustrating