Re: [libreoffice-users] Calc: Converting Formula to Value
Rich Shepard wrote: I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. 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. Regards Stephan -- 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] Calc: Converting Formula to Value
Hi, Am 31.10.2011 08:26, schrieb Stephan Zietsman: Rich Shepard wrote: I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. 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. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc: Converting Formula to Value
Am 31.10.2011 10:08, schrieb Stephan Zietsman: I just wanted to mention an alternative. which I find generally interesting, because I didn´t think of the way you mentioned, at all. And for a single cell your alternative is faster, I think. Stefan :-) -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc: Converting Formula to Value
Copy the cells and paste as unformatted text (use the icon for pasting and select unformatted text) :) Dne 29.10.2011 1:28, Stefan Weigel napsal(a): Hi Tom, Am 29.10.2011 01:21, schrieb Tom Davies: Tools - Options - LibreOffice Calc - View and then UNtick the Formulas tick box in the Display section at the top of the 2nd column. This does not *convert* formula to value. It only changes the display. ;-) Stefan -- 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] Calc: Converting Formula to Value
Hi, Am 29.10.2011 02:05, schrieb Uwe Koch Kronberg: Stefan means to select the area, copy it, go to another cell, choose edit from the menu, click on paste special and inside the menu box it opens unclick paste all, then unclick all the options below (text, date and hour, formulae, comments, formats, objects) except for numbers, which is the only option that should stay checked. Hm. Not exactly. In order to convert a formula into its result value, I wouldn´t go to *another* cell but paste special right in the *same* cell -- that means overwriting the formula by its result value. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc: Converting Formula to Value
Hi Rich, Am 29.10.2011 01:50, schrieb Rich Shepard: I'm not following you. Are you writing that I can highlight two adjacent cells and have their sum pasted in the same row in a third column? No. Follow this: (1) Select the cell that contains the formula (2) Choose Edit | Copy (3) Choose Edit | Paste Special (4) Unselect Paste all and unselect Formulas and select Numbers (5) Hit OK Done. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc: Converting Formula to Value
On Sat, 29 Oct 2011, Stefan Weigel wrote: The trick is to copy and then paste special (Edit menu). In the dialog check only numbers. Stefan, Thank you very much. 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
Re: [libreoffice-users] Calc: Converting Formula to Value
On Fri, 28 Oct 2011, The Wolfkin wrote: So if I'm understanding you're trying to say start out with cells.. input a formula like this http://minus.com/lgIwyrkPUPHj7 which gives a solution like this http://minus.com/l50sfqIxwhBlz and then now change the contents of cell D5 from {=B5+C5} to {80} so that you can delete the contents of B5 an C5 yet keep the 80 I tried this but found that the cells (in your case with '80') were filled with error messages when the source cells were removed. Changing the display of the cell contents is easy. 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
RE: [libreoffice-users] Calc: Converting Formula to Value
Or, you can open it (an .ods) in Microsoft Office 2007/2010, and save it back. That will leave the values and strip the formulas from the cells [;). It might work to save as .xslx and then reopen it in LO too, but I haven't tried that case. -Original Message- From: Stefan Weigel [mailto:stefan.wei...@bildungskreis.org] Sent: Friday, October 28, 2011 16:26 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Calc: Converting Formula to Value Hi, Am 29.10.2011 01:14, schrieb Rich Shepard: I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. The trick is to copy and then paste special (Edit menu). In the dialog check only numbers. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc: Converting Formula to Value
That was actually more of a restatement of your problem then an attempt at a solution. But the previous supplied answer of Paste Special with only Numbers checked did work. If you do that you can delete B5 and C5 and keep the 80. if you're still having trouble perhaps a screenshot would help assuming this isn't confidential work? -- I love gmail. Do you? The Wolfkin On Sat, Oct 29, 2011 at 9:20 AM, Rich Shepard rshep...@appl-ecosys.comwrote: On Fri, 28 Oct 2011, The Wolfkin wrote: So if I'm understanding you're trying to say start out with cells.. input a formula like this http://minus.com/lgIwyrkPUPHj7 which gives a solution like this http://minus.com/l50sfqIxwhBlz and then now change the contents of cell D5 from {=B5+C5} to {80} so that you can delete the contents of B5 an C5 yet keep the 80 I tried this but found that the cells (in your case with '80') were filled with error messages when the source cells were removed. Changing the display of the cell contents is easy. 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
Re: [libreoffice-users] Calc: Converting Formula to Value
Hi Rich, Rich Shepard wrote (29-10-11 01:14) I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value ... It is in Tools Options Calc View .. section display. Cheers, -- - Cor - http://nl.libreoffice.org -- 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] Calc: Converting Formula to Value
Hi, Am 29.10.2011 01:14, schrieb Rich Shepard: I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. The trick is to copy and then paste special (Edit menu). In the dialog check only numbers. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc: Converting Formula to Value
Hi Tom, Am 29.10.2011 01:21, schrieb Tom Davies: Tools - Options - LibreOffice Calc - View and then UNtick the Formulas tick box in the Display section at the top of the 2nd column. This does not *convert* formula to value. It only changes the display. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc: Converting Formula to Value
On Sat, 29 Oct 2011, Cor Nouws wrote: It is in Tools Options Calc View .. section display. Cor, In the display section is a checkbox that allows the formula or value to be displayed in each cell. What I want is to have the displayed value _replace_ the formula in each cell. Can this be done? 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
Re: [libreoffice-users] Calc: Converting Formula to Value
On Sat, 29 Oct 2011, Tom Davies wrote: and then UNtick the Formulas tick box in the Display section at the top of the 2nd column. Regards from Tom :) Tom, Yes, that changes the display, but not the cell contents. I need to change the contents to the displayed value so I can delete the columns whose sum (row-by-row) comprise the formula. 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
Re: [libreoffice-users] Calc: Converting Formula to Value
On Sat, 29 Oct 2011, Stefan Weigel wrote: This does not *convert* formula to value. It only changes the display. ;-) Stefan, That's correct. How can I convert the formula value in each cell to the value itself? 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
Re: [libreoffice-users] Calc: Converting Formula to Value
On Sat, 29 Oct 2011, Stefan Weigel wrote: The trick is to copy and then paste special (Edit menu). In the dialog check only numbers. Stefan, I'm not following you. Are you writing that I can highlight two adjacent cells and have their sum pasted in the same row in a third column? 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
Re: [libreoffice-users] Calc: Converting Formula to Value
Hi Rich, Stefan means to select the area, copy it, go to another cell, choose edit from the menu, click on paste special and inside the menu box it opens unclick paste all, then unclick all the options below (text, date and hour, formulae, comments, formats, objects) except for numbers, which is the only option that should stay checked. Good luck, El 28/10/11 20:50, Rich Shepard escribió: On Sat, 29 Oct 2011, Stefan Weigel wrote: The trick is to copy and then paste special (Edit menu). In the dialog check only numbers. Stefan, I'm not following you. Are you writing that I can highlight two adjacent cells and have their sum pasted in the same row in a third column? Rich -- Uwe Koch Kronberg Enrique Koch y Cía. Ltda. Fono: + 56 32 2543464 Fax: + 56 32 2543465 Cel: + 56 9 87177837 E-mail:uwe.k...@opticakoch.cl mailto:uwe.k...@opticakoch.cl La información contenida en este mensaje puede ser privada, confidencial y estar protegida contra la divulgación. Si el lector de este mensaje no es el receptor que se intentó contactar o un trabajador o interlocutor responsable de entregar este mensaje al receptor que se intentó contactar, usted está siendo notificado que cualquier propagación, distribución o copia de esta comunicación está estrictamente prohibida. Si ha recibido esta comunicación por error, por favor, notifíquenos de inmediato respondiendo este mensaje y eliminándolo de su computador. -- 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