Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
1  
Did you try using "paste special", unticking formulas and ticking numbers? –  Mehper C. Palavuzlar Dec 29 '11 at 8:13
add comment

1 Answer

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

enter image description here

share|improve this answer
    
Thank you very much, Mehper ! –  Rob Rijsdam Dec 29 '11 at 15:05
    
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
    
@RobRijsdam: Since the answer helped you, you should accept it. –  surfasb Dec 30 '11 at 12:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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