Convert formula results to values

Discuss the spreadsheet application

Convert formula results to values

Postby gwhitcomb » Thu Feb 12, 2009 10:33 pm

I'm an experienced Quattro Pro user and know how to convert the result of a formula in a cell to an absolute value, so that the range of cells in the formula can be deleted without losing the result.

I can't find out how to do it in scalc! Have tried the help file, have searched for my question in this forum with no result. Would someone please help? I'm using OpenOffice 3.0.1, Windows XP.
OOo 3.0.X on Ms Windows XP
gwhitcomb
 
Posts: 4
Joined: Thu Feb 12, 2009 10:26 pm

Re: Convert formula results to values

Postby Hagar Delest » Thu Feb 12, 2009 10:49 pm

I would say copy then Edit>Paste Special (or CTRL+SHIFT+V) and then Value. But there may be a quicker way to do that (MS Excel has a nice Paste>Value option when you long click the paste icon.

Please don't use the green tick mark in your thread icon, it's for solved topics!

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.1 on Windows 7 and Xubuntu 14.10 (Utopic Unicorn)
User avatar
Hagar Delest
Moderator
 
Posts: 26341
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Convert formula results to values

Postby robjhbiz » Sun Feb 15, 2009 8:37 am

In the Mac version (3.0) there is no values option under paste special. Is there a different way to do this in the Mac version?
OOo 3.0.X on Mac OSx Leopard
robjhbiz
 
Posts: 1
Joined: Sun Feb 15, 2009 8:34 am

Re: Convert formula results to values

Postby Hagar Delest » Sun Feb 15, 2009 11:37 am

No Numbers entry in the Paste special dialog? Can you upload a screenshot?
AOO 4.1.1 on Windows 7 and Xubuntu 14.10 (Utopic Unicorn)
User avatar
Hagar Delest
Moderator
 
Posts: 26341
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Convert formula results to values

Postby JohnV » Sun Feb 15, 2009 4:43 pm

Try clicking the arrow by the Paste icon and selecting Unformatted Text.
JohnV
Volunteer
 
Posts: 1538
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Convert formula results to values

Postby JohnV » Sun Feb 15, 2009 5:00 pm

Hagar,
No Numbers entry in the Paste special dialog?

Check above. You said "Value", he said no "values" so literally he's correct but...
JohnV
Volunteer
 
Posts: 1538
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Convert formula results to values

Postby Hagar Delest » Sun Feb 15, 2009 5:48 pm

OK. I see. I had written that by memory. And I may be wrong with 'Numbers' because I'm not on my machine and that's a French UI. But... indeed it should not prevent the user from trying similar options in the dialog.
AOO 4.1.1 on Windows 7 and Xubuntu 14.10 (Utopic Unicorn)
User avatar
Hagar Delest
Moderator
 
Posts: 26341
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Convert formula results to values

Postby ronbrick » Fri Oct 01, 2010 10:07 pm

to convert formula to results or values on an open office spread sheet
http://www.oooforum.org/forum/viewtopic.phtml?t=16595
use paste special and un-tick 'all values' and tick all others except "formula'

this does the same as paste special - Values on MicroMouse Excel
the latest result of the formula is fixed in the cell or cells thus pasted.
this is useful for keeping a record of values at a given time, date.
why is this not in the Help
open office 3.2.1
on Mac OS X Version 10.6.4
ronbrick
 
Posts: 1
Joined: Fri Oct 01, 2010 9:55 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests