How to copy and paste only data from the spread sheet ? [closed]
If cell A2 contains =(2+2). After pasting I want cell as 4 hard coded instead of formula.
First time here? Check out the FAQ!
If cell A2 contains =(2+2). After pasting I want cell as 4 hard coded instead of formula.
Press F2-F9-Enter-Enter
or
Ctrl+C, right click an choose Paste Only-Number
or
Ctrl+C, Ctrl+Shift+V (Edit - Paste Special)
F2 (Edit mode), F9 (Recalculate formula to value), first Enter - insert result of recalculation to cell, second Enter - finish edit cell
@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)
Asked: 2013-10-18 12:15:05 +0100
Seen: 28,197 times
Last updated: Oct 19 '13
Are there plans for a "papercut" project for libreoffice [closed]
Paste hangs LibreOffice Calc [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
How is this question invalid? I just came here for exactly the same reason as the OP.
For a similar question, see question 59306.