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

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

raviteja
1 ●1 ●1 ●1

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

manj_k
11020 ●15 ●68 ●104

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

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

Comments

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

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

For a similar question, see question 59306.

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

add a comment

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

JohnSUN

12092 ●10 ●54 ●129

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)

PasteNumber

edit flag offensive delete link

Comments

@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 ( 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 ( 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 ( 2013-10-18 13:51:32 +0100 )edit

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

ROSt52 ( 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 ( 2013-10-19 10:33:46 +0100 )edit

add a comment

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

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

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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

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

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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

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