Ask Your Question

Where is "Paste Special > Value" in LibreOffice? [closed]

asked 2015-10-11 13:29:46 +0100

DP789 gravatar image

I can't find a feature similar to Microsoft Excel "Paste Special > Value" in LibreOffice. Excel has "Paste Special > Value", which copies the current value of the cell to the target cell.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-02-07 21:49:10.683433

3 Answers

Sort by » oldest newest most voted

answered 2015-10-12 19:02:46 +0100

pierre-yves samyn gravatar image


In case you want to convert formula cells into static values : menu ToolsCell ContentsFormula to Value.

Previously, you would need to cut the cells and paste them back into place to have the same outcome.


edit flag offensive delete link more

answered 2017-11-25 13:57:34 +0100

quazgar gravatar image

The options Paste only (right-click menu) and Paste special are greyed out when there is nothing in the clipboard. Note that this is the case after you paste the clipboard content to another location, so you may need to copy the original content again.

edit flag offensive delete link more

answered 2015-10-12 18:00:29 +0100

Edward gravatar image

Right Clicking on your target cell will give several options. PASTE ONLY allows you to select TEXT, NUMBER, or FORMULA. PASTE SPECIAL gives you those and more options (keep source formatting, or not; transpose, etc)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-10-11 13:29:46 +0100

Seen: 10,047 times

Last updated: Nov 25 '17