https://bugs.documentfoundation.org/show_bug.cgi?id=163375
BogdanB <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|x86-64 (AMD64) |All CC| |[email protected] | |g Keywords|bibisectRequest |bibisected Regression By| |balazs.varga.extern@allotro | |pia.de OS|Windows (All) |All --- Comment #8 from BogdanB <[email protected]> --- Balazs, please, can you take a look? 4015a3f066a322f1215a177150f9f3f90f3b2434 is the first bad commit commit 4015a3f066a322f1215a177150f9f3f90f3b2434 Author: Jenkins Build User <[email protected]> Date: Fri Mar 22 10:10:25 2024 +0100 source sha:ba0ec4a5d2b025b675410cd18890d1cca3bc5a2f source sha:ba0ec4a5d2b025b675410cd18890d1cca3bc5a2f instdir/program/libsclo.so | Bin 25395080 -> 25395080 bytes instdir/program/setuprc | 2 +- instdir/program/versionrc | 2 +- 3 files changed, 2 insertions(+), 2 deletions(-) tdf#159687 sc formula SUMPRODUCT performance fix: add more binary operators which need to be checked if they are next to a trimmable DoubleRef arguments or not. Example: =SUMPRODUCT(($D:$D>M47:M47)*($D:$D<M48:M48)*($I:$I=N$41)) --> $D:$D and $I:$I columns are trimmable. Recalculation of formulas with a lot of SUMPRODUCT where we comparing full columns could take minutes during editing a sheet. With reducing the size of the compared ranges to the actual data could significantly speed up the recalculation. This takes the recalculation time from ~50 sec to <1 sec on my machine. Note: probabaly the same could be applied to the SUM function. Change-Id: I758660d0b638ef7255bd5a41a96755289b5a2b41 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/165074 Tested-by: Jenkins Reviewed-by: Noel Grandin <[email protected]> Reviewed-by: Balazs Varga <[email protected]> -- You are receiving this mail because: You are the assignee for the bug.
