What is in LibreOffice Calc the equivalent to Excel's "Paste Special > Value"?

Question

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?

Solution

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

Comments

[Greg Jennings]

Did you try using "paste special", unticking formulas and ticking numbers?

[Admin]

So why can't you leave it on #'s instead of UNTICKING everything and ticking numbers? Isn't that what we want to do?

[Rob Rijsdam]

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

[neverfox]

Still a lot of extra steps compared to Excel. Did M$ patent this feature or something?

[EoghanM]

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).