https://bugs.freedesktop.org/show_bug.cgi?id=66507

--- Comment #18 from Michael Meeks <michael.me...@collabora.com> ---
Just pushed a speedup to master; one of the problems is optimising sumproduct
with these nested week / day functions; an initial attempt noticing that we do:

 747011 calls to getMonth for 0 and getYear for 0

ie. for all the blank cells (the sumproduct is over a big range with ~nothing
in it) - I shortcut the Date += operator to avoid quite some work; ~2 lines of
code.

That gives a 12% win on switching to the slow sheet (forcing calculate) and
some real but smaller win on load time.

Clearly there is plenty more to do here still =)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to