Re: gnumeric is slow on certain operations

[Frederic Parrenin <parrenin gmail com>]

Dear Morten,

Thank you very much for your answer.

Would not it be possible to make two cases, one when such functions are called (and one need to recalc) and one when such functions are not called (and one does not need to recalc)?

My version of gnumeric is 1.10.13.

I put a sample spreadsheet here:

http://parrenin.frederic.free.fr/download/bugzilla/Ice-synchros-2011-07-07.gnumeric

I will file a bug in bugzilla.

Thank you again,

Frédéric

2011/7/12 Morten Welinder <mortenw gnome org>

> I am working with a huge spreasheet and find gnumeric anormaly slow for some
> operations, like inserting new cells, which should not invoke recalculating
> everything.

It does, however.  Some functions are sensitive to where
they are called from.  ROW, COLUMN, and INDIRECT for example.
Therefore we need to recalculate moved cells and anything that
depends on them.  If I remember correctly we just ask for
recomputation of everything because it is, in general, faster
than trying to follow dependents of a very large area.

But that doesn't explain why things are slow to begin with.
To evaluate that we would need to see a sample spreadsheet
that misbehaves.  (And you should make sure you are using
a recent version.)  bugzilla.gnome.org is best for this.

A workaround worth trying is to turn off automatic recomputation.

Morten

--
http://parrenin.frederic.free.fr/