Created attachment 182708 [details] Simple Macro recreating performance issue in v7.3+ Setting cell property value takes significantly longer in v7.3+, runs quickly in v7.2.7.2. attached is a macro that runs setPropertyValue for horizontal justification and font size over 3 tests of 100, 200 and 1000 records. These are our test results for reference: LibreOffice 7.2.7.2 Run 1: 5 seconds, 3 seconds and 28 seconds Run 2: 1 second, 1 second, 7 seconds LibreOffice 7.4 Run 1: 33 seconds, 62 seconds, 321 seconds Run 2: 30 seconds, 59 seconds, 284 seconds
I could not reproduce the issue. Basically I got the same performance in 7.2, 7.3 and 7.4. What OS are you using? Here are my results: LibreOffice 7.2.7.2 Run 1: 2 seconds, 2 seconds and 18 seconds Run 2: <1 second, 1 second, 3 seconds LibreOffice 7.3.6.2 Run 1: 2 seconds, 2 seconds and 12 seconds Run 2: <1 second, 1 second, 3 seconds LibreOffice 7.4.1.2 Run 1: 2 seconds, 2 seconds and 12 seconds Run 2: <1 second, 1 second, 3 seconds System info Version: 7.2.7.2 / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL Version: 7.3.6.2 / LibreOffice Community Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL Version: 7.4.1.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.22.04.1~lo1 Calc: threaded
Our local machines are running x64 Windows. We saw similar issues on our Linux RHEL 8.5 machines.
need to edit my previous comment: RHEL 8.6*
(In reply to arthur wilson from comment #2) > Our local machines are running x64 Windows. We saw similar issues on our > Linux RHEL 8.5 machines. I'm running on Kubuntu 22.04. Let's wait and see if anyone else can reproduce your results.
Funny: 0 3 23 sec in Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 85353c42de80e7492f5c80499e18375f942c75c9 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: threaded but 15 27 168 sec in Version: 7.4.0.0.alpha1+ (x64) / LibreOffice Community Build ID: f3b5cb5a17a451c9e7d9b47b5e8854c5e126801f CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: threaded I would wait to 7.4.2 release and retest it. It seems already fixed in master. Or we can search the commit if it will still not fixed in 7.4.2.
Arthur could you please retest it yourself in latest 7.4.2 version?
Sure, I'll update with my findings. Thanks
Hi Roman. I tested our platform against 7.4.2.3 and everything is looking good. we can close this ticket thanks!
[Automated Action] NeedInfo-To-Unconfirmed