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+h...@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