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 <rshepard@appl-ecosys.com>wrote:

> 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