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

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

First time here? Check out the FAQ!

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

add a comment

0

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

QED ?

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)

0

Hello

- 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`

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.

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

Seen: **811 times**

Last updated: **Feb 01**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.