[Solved] Pasting Values

Discuss the spreadsheet application

[Solved] Pasting Values

Postby jerrytex » Sat Dec 14, 2019 4:11 am

Excel has a way to convert a formula in a cell to values. First you highlight the range, then you do a Copy. Then you do a Paste Special. From the drop down menu, select Values. Is there a way to convert a formula to values in Calc?
Last edited by MrProgrammer on Sun Dec 15, 2019 6:53 pm, edited 2 times in total.
Reason: Tagged ✓ [solved]
Gerald G Barrett
Apache OpenOffice 4.1.7
Windows 7
jerrytex
 
Posts: 3
Joined: Sat Dec 14, 2019 3:58 am

Re: Pasting Values

Postby robleyd » Sat Dec 14, 2019 4:27 am

What happens if you try those steps in Calc?
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3145
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Pasting Values

Postby jerrytex » Sat Dec 14, 2019 4:35 am

First I do the copy. Then I click on the Paste drop down menu. There are 9 choices: GDI Metafile, PNG Bitmap, Bitmap, calc8, DDE link, Unformatted text, DIF, Formatted Text (RTF), and HTML. I just now tried the two text options. They both seem to work! Case closed.
Gerald G Barrett
Apache OpenOffice 4.1.7
Windows 7
jerrytex
 
Posts: 3
Joined: Sat Dec 14, 2019 3:58 am

Re: Pasting Values

Postby RusselB » Sat Dec 14, 2019 6:55 am

That Paste Special menu is what I see when using Paste Special with text from the internet in the Windows clipboard or there is nothing in the Windows clipboard.
The Paste Special dialog (not menu), that I see looks like
Paste Special dialog.JPG

If you ensure that Formulas is unchecked, then you'll paste the results of the formulas, rather than the formulas themselves.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Pasting Values

Postby jerrytex » Sat Dec 14, 2019 3:57 pm

Thanks Russell B. I am new to OpenOffice and have not yet explored all the menu options in Calc. I didn't realize there was a Paste Special option under the Edit menu.
Gerald G Barrett
Apache OpenOffice 4.1.7
Windows 7
jerrytex
 
Posts: 3
Joined: Sat Dec 14, 2019 3:58 am

Re: Pasting Values

Postby RusselB » Sat Dec 14, 2019 6:42 pm

Your welcome.,.. and as to being new, we all were at some point.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 7 guests