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

calc

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

DP789
1 ●1 ●1 ●1

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

add a comment

1

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

pierre-yves samyn
13076 ●2 ●19 ●69

Hi

In case you want to convert formula cells into static values : menu Tools ▸ Cell Contents ▸ Formula 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

add a comment

0

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

quazgar
48 ●3 ●5 ●8

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

add a comment

0

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

Edward
637 ●12 ●18 ●26

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

add a comment

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

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

Question Tools

Stats

Related questions

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

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

Question Tools

Stats

Related questions

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

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