Re: [libreoffice-users] Re: Calc: Converting Formula to Value
Hi :) Ooops. Yep i made a few mistakes there. Using x as multiplication confuses some people and * confuses others so i went back to make it a simple addition but really was not concentrating at all lol. Hopefully it gets the point across tho. Many apols for the blunders and regards from Tom :) --- On Sat, 29/10/11, Brian Barker b.m.bar...@btinternet.com wrote: From: Brian Barker b.m.bar...@btinternet.com Subject: Re: [libreoffice-users] Re: Calc: Converting Formula to Value To: users@global.libreoffice.org Date: Saturday, 29 October, 2011, 16:38 At 15:43 29/10/2011 +0100, Tom Davies wrote: A1= 10 B1= 20 and C1= A1+B1 then the spreadsheet would display C1= 200 ... Is this perhaps what's known as the new math? Brian Barker -- 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 -- 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
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+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