Re: [libreoffice-users] Re: Calc: Converting Formula to Value

Hi :)
So you want a static value instead of a formula?  If any of the values that the formula is based on 
were to change then the value in the cell would not change.
eg if 
A1= 10
B1= 20
and 
C1= A1+B1
then the spreadsheet would display C1= 200 but you would still be able to see the formula in the 
top entry widget.  A printout would not show the formula, it would just show the value.  If you 
changed the value of A1 to 30 then C1 would now show the result as being 600.  

If you were to set the formula bar (the entry widget) to show the value of C1 as 200 then changing 
A1 to 30 would have no effect on C1, it would still show the value 200.

In effect the formula bar / entry widget shows what some people might think of as coding that lays 
under the surface of what is being displayed

You can copy&paste an entire column or row as fixed values to another column or row by using "paste 
special" and that might be a useful way of seeing if any of the calculated values change over time. 
 
Regards from
Tom :)


--- On Sat, 29/10/11, Rich Shepard <rshepard@appl-ecosys.com> wrote:

> From: Rich Shepard <rshepard@appl-ecosys.com>
> Subject: Re: [libreoffice-users] Re: Calc: Converting Formula to Value
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 0:48
> On Fri, 28 Oct 2011, Tom wrote:
>
> > It depends what Rich means by "change".
>
>   Show the value in each cell, not the display of the
> formula. That is, when
> the cursor is on a cell the entry widget along the top
> should display the
> value, not the formula.
>
> > There are other possibilities too, such as perhaps the
> cell has been
> > defined as text, perhaps '= blah blah in which case
> removing the ' might
> > do the trick.
>
>   No, when the formula was defined the cell contents
> were both numeric so
> the formula value is also numeric.
>
> > I think that between us we have answered the most
> likely reasons that
> > would give Rich formulas rather than values.
>
>   Actually, not. I need to know how to convert the
> formula to its value.
>
> Thanks,
>
> Rich
>
>
>
> -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived
> and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted