[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #35 from adnanbal...@gmail.com --- 26 seconds in Office 2021 LTSC v2111 14701.20226 This time is for 10,000 rows. The daily build I downloaded is now doing it in roughly 2 seconds! I'm speechless. AMAZING WORK, GUYS! I hope

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #34 from stragu --- Following the steps in comment 10, it took about 15 seconds to paste 187,280 cells with COUNTIFS(), in the latest LO 7.4 alpha on Ubuntu 20.04. I don't have a GPU. Marking as VERIFIED FIXED. Version:

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 stragu changed: What|Removed |Added Status|RESOLVED|VERIFIED --- Comment #33 from stragu

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #32 from Luboš Luňák --- *** Bug 144257 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Luboš Luňák changed: What|Removed |Added Resolution|--- |FIXED Status|NEW

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #31 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/c05c826bd18eedaa7720ff0817b5c796435dbc02 search faster an array

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #30 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/a49afabb0cf1eac8f1214bfada0d7c9bc662878e reduce size of *IFS

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #29 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/248e49d3f409d414331945ba91b3083406d59f78 no PerformQuery() with

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Commit Notification changed: What|Removed |Added Whiteboard||target:7.4.0 -- You are

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-05-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Luboš Luňák changed: What|Removed |Added CC||dlynch1...@googlemail.com ---

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-01-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #27 from Shad Sterling --- It's even weirder than that: if reopening the file doesn't hang immediately, if I click on the cell it hangs, but if I use the keyboard to navigate to the cell it does not hang; I can use the

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-01-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #26 from Shad Sterling --- The problem I reported in bug 146546 seems to be triggered by selecting a cell that contains the triggering formula, but not when recalculating that same cell in response to changes in referenced

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-01-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #25 from Shad Sterling --- I'm not sure bug 146546 is a duplicate of this; see bug 146546 comment 5 -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2022-01-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Luboš Luňák changed: What|Removed |Added CC||m...@shadsterling.com --- Comment

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #23 from adnanbal...@gmail.com --- Situation as of today: 372 seconds in LO 7.3.0.1 355 seconds in LO 7.4.0.0.alpha0+ 185 seconds in LO 7.3.0.0alpha0+ 28 seconds in Office 2021 LTSC v2111 14701.20226 Version: 7.3.0.1 (x64) /

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Julien Nabet changed: What|Removed |Added Attachment #176681|0 |1 is obsolete|

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #22 from Julien Nabet --- Created attachment 176778 --> https://bugs.documentfoundation.org/attachment.cgi?id=176778=edit Flamegraph Here's a new Flamegraph on pc Debian x86-64 with master sources updated today

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #21 from adnanbal...@gmail.com --- It would be nice to have some performance based unit tests to avoid such regressions in future. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Julien Nabet changed: What|Removed |Added CC||l.lu...@collabora.com ---

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Julien Nabet changed: What|Removed |Added Attachment #175430|0 |1 is obsolete|

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #19 from Julien Nabet --- Created attachment 176681 --> https://bugs.documentfoundation.org/attachment.cgi?id=176681=edit Flamegraph I retrieved a new Flamegraph on pc Debian x86-64 with master sources updated today (gen

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-12-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #18 from adnanbal...@gmail.com --- Calculation time has regressed to twice as slow since Build ID 459f9de8a87373c826eadab142850cc3fa578fca. Version: 7.3.0.0.beta1+ (x64) / LibreOffice Community Build ID:

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-10-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #17 from adnanbal...@gmail.com --- The daily build shows some improvement, with total calculation time for 10,000 rows reduced from 238 seconds to 203 seconds. I have noticed that in some calculations, when the string "Adapt

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #16 from Eike Rathke --- > compareByValue() and compareByString Bah, of course I meant isQueryByValue() and isQueryByString() as it's also documented. -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #15 from Eike Rathke --- Order of evaluation matters, as compareByValue() and compareByString() may deliver an exact match and only if they didn't then compareByRangeLookup() is to be tried; see also its comment at

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #14 from Julien Nabet --- Forget about of course: 3077 if (aRes.first && aRes.second) 3078 break; it's not in the if/else if part. -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Julien Nabet changed: What|Removed |Added CC||er...@redhat.com,

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #12 from Julien Nabet --- Created attachment 175430 --> https://bugs.documentfoundation.org/attachment.cgi?id=175430=edit perf flamegraph Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Xisco Faulí changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Xisco Faulí changed: What|Removed |Added Resolution|DUPLICATE |--- Status|RESOLVED

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #9 from Xisco Faulí --- Created attachment 175389 --> https://bugs.documentfoundation.org/attachment.cgi?id=175389=edit sample document -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #8 from Xisco Faulí --- (In reply to Michael Warner from comment #2) > Hmm, I suppose you might say to use > https://bugs.documentfoundation.org/attachment.cgi?id=174642 from Bug 144159. Nevermind, I've just seen this

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #7 from Xisco Faulí --- (In reply to adnanbaloch from comment #6) > Hi Xisco, > > Just wanted to point out that this is a request for enhancement and not > really a duplicate of 144159. I was hoping that someone could

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #6 from adnanbal...@gmail.com --- Hi Xisco, Just wanted to point out that this is a request for enhancement and not really a duplicate of 144159. I was hoping that someone could explore possibilities of further improving the

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC|

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #3 from adnanbal...@gmail.com --- Yes, that is correct. In that document, countifs() on 10,000 rows takes 84 seconds in Excel but 238 seconds in Calc. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 --- Comment #2 from Michael Warner --- Hmm, I suppose you might say to use https://bugs.documentfoundation.org/attachment.cgi?id=174642 from Bug 144159. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

2021-09-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144777 Michael Warner changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0