Ask Your Question

How to copy and paste only data from the spread sheet ? [closed]

asked 2013-10-18 12:15:05 +0100

raviteja gravatar image

updated 2013-10-21 22:01:27 +0100

manj_k gravatar image

If cell A2 contains =(2+2). After pasting I want cell as 4 hard coded instead of formula.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 03:52:27.473172


How is this question invalid? I just came here for exactly the same reason as the OP.

quazgar gravatar imagequazgar ( 2017-11-25 13:50:51 +0100 )edit

For a similar question, see question 59306.

quazgar gravatar imagequazgar ( 2017-11-25 13:58:36 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-10-18 12:26:20 +0100

JohnSUN gravatar image

updated 2013-10-18 13:07:25 +0100

Press F2-F9-Enter-Enter



Ctrl+C, right click an choose Paste Only-Number

Paste from context menu


Ctrl+C, Ctrl+Shift+V (Edit - Paste Special)


edit flag offensive delete link more


@JohnSUN, what is "F2-F9-Enter-Enter" supposed to do? It doesn't work in LO 4.1.3 under Windows XP

Thanks for the Paste Only > Number. I had never noticed that and it is VERY useful!

Pedro gravatar imagePedro ( 2013-10-18 12:32:03 +0100 )edit

F2 (Edit mode), F9 (Recalculate formula to value), first Enter - insert result of recalculation to cell, second Enter - finish edit cell

JohnSUN gravatar imageJohnSUN ( 2013-10-18 12:49:26 +0100 )edit

@Pedro I meant that there is a quick and easy way to replace the formula in the cell at the result. For example, after the usual copy-paste (Ctrl+C - Ctrl+V) you get a formula in a cell . And then press the four buttons and the formula changed to just a number (or text, or date)

JohnSUN gravatar imageJohnSUN ( 2013-10-18 13:51:32 +0100 )edit

@JohnSUN - this is indeed a nice way for single cells! Thanks!

ROSt52 gravatar imageROSt52 ( 2013-10-19 06:11:55 +0100 )edit

@JohnSUN, I see now what you mean. Thank you for the explanation and for the animated GIF image description

Pedro gravatar imagePedro ( 2013-10-19 10:33:46 +0100 )edit

Question Tools

1 follower


Asked: 2013-10-18 12:15:05 +0100

Seen: 24,250 times

Last updated: Oct 19 '13