Ask Your Question

how do i paste absolute values, like paste special > values

asked 2019-08-15 14:32:56 +0200

rudgeworks gravatar image

When i use a formula - how do i paste absolute values, as i would useing "paste special" > "values" in MS excel?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-02-01 10:31:25 +0200

John Murrell gravatar image

updated 2020-02-01 10:31:44 +0200

It does not work like Excel

The function used to be under Tools - Formula to Value

It has now moved to data - Calculate - Formula to Value


edit flag offensive delete link more


This is not an answer to what you asked - You asked about paste and this answer is about conversion of formula to values.

Opaque gravatar imageOpaque ( 2020-02-01 15:06:06 +0200 )edit

In Excel Paste Special Values converts the result of the formula in a cell to a value ir it removes the formula. In Excel you can paste 'over the top of' the selected cells thus removing the formula and ending with values. This is apparently not allowed in Calc. It appears that in Calc you can paste special - Values into other cells but not into the source cells.

As a result you have to use the calc function 'Formula to Value' if you want the result in the cells that used to have formula.

Neither spreadsheet has the ability to paste special absolute values as far as I am aware so I believe the person who asked the question had already used the ABS function to get the absolute value in the cell(s) and was attempting to convert this to a value rather than having the result as a ...(more)

John Murrell gravatar imageJohn Murrell ( 2020-02-01 17:07:34 +0200 )edit

answered 2019-08-15 14:40:17 +0200

Opaque gravatar image

updated 2019-08-15 15:39:40 +0200


  • Copy your source cell (CTRL-C or Right click - Copy)
  • Move to your target cell
  • Right click -> Paste special and make your selection what to paste (plenty of options) -- or -- use Edit -> Paste Special...

I assume this doesn't differ much from Excel.

Update - see screenshot (copying cell A3, moving to target A5 and Paste Special -> Number will add value 3 to A5

image description

edit flag offensive delete link more


There is no obvious way of pasting the resultant value of a formula - ie cell contains =a1+b1 in excel I can copy the cell and use paste special .. values to past the result of the formula ( but not the formula it’s self) or am I missing something.

rudgeworks gravatar imagerudgeworks ( 2019-08-15 14:54:12 +0200 )edit

Did you even try what I wrote - The procedure in my answer pastes the result of a formula and not the formula itself. That's why it is called Paste special as it does in Excel. Please see Update in my answer.

Opaque gravatar imageOpaque ( 2019-08-15 15:04:06 +0200 )edit

See my answer - that works Ok.

John Murrell gravatar imageJohn Murrell ( 2020-02-01 10:32:23 +0200 )edit

how do i paste absolute values

Your answer answers something you did not ask.

Opaque gravatar imageOpaque ( 2020-02-01 15:06:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-15 14:32:56 +0200

Seen: 811 times

Last updated: Feb 01