In my professional life, I'm limited to use Microsoft Office. In Excel there is an option ows to render the result of a formula to be pasted as a "fixed value".

For instance A1 = "I",B1 = "ride", C1 = "a" and D1 = "bike"
In E1, I can place a formula to concatenate the values of A1 through D1 to display the sentence "I ride a bike", but if I should copy and paste that cell, I would just get the formula again, both if I write the formula with relative positioning, and if the values in A1:D1 change.
To solve this problem, Excel has "Paste Special > Value", which copies the current value of the cell to the target cell.

At home, I use LibreOffce.
Although I have tried to find a feature identical to "Paste Special > Value" in both LibreOffice and OpenOffice.org, I couldn't find it.
Does anyone know how to do this?

  • 2
    Did you try using "paste special", unticking formulas and ticking numbers? – Mehper C. Palavuzlar Dec 29 '11 at 8:13
  • So why can't you leave it on #'s instead of UNTICKING everything and ticking numbers? Isn't that what we want to do? – user322501 May 13 '14 at 13:50

Just hit SHIFT+CTRL+V or Paste Special... from the Edit menu, unselect Paste all, and select Text or Numbers:

enter image description here

  • Good afternoon, Mehper, I have tried that one before, but it didn't work. Following your advice, I tried again and now it worked like a charm... So in all humbleness, it leaves me nothing but the conclusion that earlier I must have done something wrong:-) Thank you very much for your assistance and have a nice day ! Best regards, Rob – Rob Rijsdam Dec 29 '11 at 15:13
  • Still a lot of extra steps compared to Excel. Did M$ patent this feature or something? – neverfox Jun 25 '14 at 2:26
  • The fact that the state of 'Paste all' enables all the checkboxes below it is completely non obvious (I thought they were disabled for some reason related to the data that I'd copied). – EoghanM Feb 5 '17 at 14:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.