https://bugs.documentfoundation.org/show_bug.cgi?id=144159
Bug ID: 144159 Summary: [1] Countifs() performance regression Product: LibreOffice Version: 7.2.0.4 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: adnanbal...@gmail.com Description: I have an Excel sheet with data in 187,000 rows. I use this sheet to benchmark Calc to see if countifs() calculation speed has improved with a new version. I calculate countifs() with two criteria and fill 10,000 rows with the results. Previously, it would take around 350 seconds to complete. Now, even for 500 rows, the countifs() formula is not able to finish the calculation after more than 120 seconds. Steps to Reproduce: 1.Create large number of random data at least in at two columns with 187,000 rows. 2.Run countifs with two criteria on the data to return result in 10,000 rows. Actual Results: countifs() keeps on running and does not return any result even after more than 6 minutes. Expected Results: It used to return the results within 350 seconds on my i7-4770. Also tried it on a newer laptop with Core i3-115G4 CPU. Calc 7.1.5 completes the calculation in 326 seconds on the i3. Calc 7.2.0.4 doesn't complete even after 6 minutes. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: OpenGL version 3.0 to 4.3 features are enabled. -- You are receiving this mail because: You are the assignee for the bug.