Ask Your Question
0

Where is "Paste Special > Value" in LibreOffice?

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

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 close merge delete

3 Answers

Sort by » oldest newest most voted
1

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

pierre-yves samyn gravatar image

Hi

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.

Regards

edit flag offensive delete link more
0

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

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
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 6,924 times

Last updated: Nov 25 '17