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 love gmail. Do you? The Wolfkin On Fri, Oct 28, 2011 at 7:50 PM, Rich Shepard <rshep...@appl-ecosys.com>wrote: > 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+help@global.libreoffice.** > org <users%2bh...@global.libreoffice.org> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<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