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