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