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+help@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