https://bugs.documentfoundation.org/show_bug.cgi?id=146570
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #3 from m.a.riosv <[email protected]> --- I can't find from where the 800 expected comes. Only opening the file, about 585 MB. After paste and after a while it is reduced to 2,5 GB, without touch nothing. After a hard recalc 1,7 GB, takes several minutes. So I don't know if it is really a bug or a possibility of enhancement. BTW, there are a lot of formulae with OFFSET() which is a volatile function, maybe where possible replace it with INDEX() could help a bit on the calculation's speed, and perhaps SUM() in arrays with SUMPRODUCT(). -- You are receiving this mail because: You are the assignee for the bug.
