Re: Replacing formula result with result

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
Copy, then paste "as value".


Ryan Pavlik

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

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]