[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Jim Raykowski changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Adolfo Jayme Barrientos changed: What|Removed |Added Whiteboard|target:7.5.0 target:7.4.2 |target:7.5.0

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #16 from Commit Notification --- Luboš Luňák committed a patch related to this issue. It has been pushed to "libreoffice-7-4-1": https://git.libreoffice.org/core/commit/276037edb6f98ec1fa64e8740958668a1b30cef2 fix undoing

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Commit Notification changed: What|Removed |Added Whiteboard|target:7.5.0 target:7.4.2 |target:7.5.0 target:7.4.2

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #15 from Commit Notification --- Luboš Luňák committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/e20d52afe5a33ae9490e238e7b5833d3df68f004 fix undoing

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Commit Notification changed: What|Removed |Added Whiteboard|target:7.5.0|target:7.5.0 target:7.4.2

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #14 from Luboš Luňák --- (In reply to Kevin Suo from comment #12) > (In reply to Luboš Luňák from comment #11) > > > This most probably takes 30s because the document uses <> operator in > > lookup operations... > > Maybe

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #13 from Julien Nabet --- (In reply to Luboš Luňák from comment #11) > This most probably takes 30s because the document uses <> operator in lookup > operations, which is currently not optimized with ScSortedRangeCache

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #12 from Kevin Suo --- (In reply to Luboš Luňák from comment #11) > This most probably takes 30s because the document uses <> operator in lookup > operations... Maybe off-topic, but do you have any idea what settings

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #11 from Luboš Luňák --- This most probably takes 30s because the document uses <> operator in lookup operations, which is currently not optimized with ScSortedRangeCache because it needs two ranges in the sorted data (each

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Julien Nabet changed: What|Removed |Added Attachment #182039|0 |1 is obsolete|

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #10 from Julien Nabet --- Created attachment 182079 --> https://bugs.documentfoundation.org/attachment.cgi?id=182079=edit Flamegraph Here's an updated Flamegraph if we can do a bit more than just come back to the initial

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Kevin Suo changed: What|Removed |Added Status|RESOLVED|VERIFIED --- Comment #9 from Kevin

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Luboš Luňák changed: What|Removed |Added Resolution|--- |FIXED Status|NEW

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #8 from Commit Notification --- Luboš Luňák committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/690458889fd875a7885b692d3204c45c5016b925 fix undoing range

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Commit Notification changed: What|Removed |Added Whiteboard||target:7.5.0 -- You are

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 --- Comment #7 from Kevin Suo --- 34s with the patch on: https://gerrit.libreoffice.org/c/core/+/138880 -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 150618] Serious performance regression: it takes 5min+ for SUMIFS formula recalculation when switching sheet (while it only takes 30s in 7.3)

https://bugs.documentfoundation.org/show_bug.cgi?id=150618 Kevin Suo changed: What|Removed |Added Summary|Serious performance |Serious performance