[libreoffice-users] Re: Calc: Converting Formula to Value
Stephan Zietsman sziets at gmail.com writes: Stefan Weigel wrote: Am 31.10.2011 08:26, schrieb Stephan Zietsman: Select the relevant cell and click in the formula bar. Press F9 (the default short-cut for recalculate) followed by ENTER. This should replace the formula with the result. This will work for a single cell, but will take you very long for a whole column. Good point. Using Paste Special method would work better in that case. As a side note, I think the Paste Special method is more intuitive (in general); I just wanted to mention an alternative. Regards Stephan Doing the following sure makes me miss Lotus 1-2-3. I wanted to change a simple addition formula that summed the quantities in two cells into their summed value. I right-clicked the cell and hit Ctrl C. Then again I right clicked the (same) cell and rolled down to Paste special and left-clicked it. The formula was changed into its value. In the 1-2-3 days one picked the cell or cells, hit the slash key and then the keys r and v in that sequence and one had the values instead of the formulas. Trackballing and mousing are slower than the second coming. -- To unsubscribe e-mail to: users+unsubscr...@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
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
[libreoffice-users] Re: Calc: Converting Formula to Value
Hi :) It depends what Rich means by change. 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. I think that between us we have answered the most likely reasons that would give Rich formulas rather than values. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Calc-Converting-Formula-to-Value-tp3462339p3462394.html Sent from the Users mailing list archive at Nabble.com. -- 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