Re: Replacing formula result with result

[Ryan Pavlik <abiryan ryand net>]

Berthold Höllmann wrote:
> Is there a function to replace the cell content by the result of the
> formula for this cell?
>
> I have a file where one sheet accesses some other sheets in lots of
> cells via vlookup. This is quite slow in loading and adding a value to
> a column searched through by vlookup. The results of the formula won't
> change anymore for lots of cells, and I would like to replace the
> formulae for these cells by the calculation results. Is there a way of
> marking an area and calling some command to do the conversion?
>
> I am currently using gnumeric 1.7.11 if it matters.
>
> Kind regards
> Berthold
>   
Copy, then paste "as value".

Ryan

--
Ryan Pavlik
www.cleardefinition.com

#282  +  (442) -  [X]
A programmer started to cuss
Because getting to sleep was a fuss
As he lay there in bed
Looping 'round in his head
was: while(!asleep()) sheep++;