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 <mort...@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/
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
