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

asked 2016-10-06 18:49:41 +0100

JG101 gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-13 09:06:24.610730


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.

mark_t gravatar imagemark_t ( 2016-10-07 17:33:26 +0100 )edit

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

JG101 gravatar imageJG101 ( 2016-10-11 19:07:02 +0100 )edit

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

JG101 gravatar imageJG101 ( 2016-10-11 19:31:39 +0100 )edit