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

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