Re: [libreoffice-users] Calc: Converting Formula to Value

Stefan Weigel wrote:
> Am 31.10.2011 08:26, schrieb Stephan Zietsman:
> > Select the relevant cell and click in the formula bar.  Press F9 (the
> > default short-cut for recalculate) followed by ENTER.  This should
> > replace the formula with the result.
>
> This will work for a single cell, but will take you very long for a
> whole column. ;-)

Good point.  Using Paste Special method would work better in that
case.  As a side note, I think the Paste Special method is more
intuitive (in general); I just wanted to mention an alternative.

Regards
Stephan

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