https://bugs.documentfoundation.org/show_bug.cgi?id=151406
Bug ID: 151406
Summary: CALC: Changing cell background via macro is very slow
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Created attachment 182902
--> https://bugs.documentfoundation.org/attachment.cgi?id=182902&action=edit
Diagnostic macros
After upgrading LO to 7.4 from 7.1 we have found that some macros "hang", I
have narrowed it down to a for loop that is changing cell style in an entire
row. Part of the problem is that 7.4 allows for many more columns, than 7.1,
but even if I limit the number of columns in 7.4 to 1024, it is still much
slower, than 7.1
The attached file contains macros that were used to narrow down the nature of
the bug, there are two entry subroutines runAs71 and runAsDefault, both setup
the test and run it, the main difference is that runAsDefault on 7.4 will try
to iterate over every column in row 5 while runAs71 will only iterate over 1024
columns. You can adjust the number of runs (I have set it to 10) and time
sampling interval (I have set it to 100 iterations)
For example sub runAs71 from attached testing macro in 7.1 gives the following
results:
Total Time = 12658ms
Avg. min = 82,2ms, avg. max = 161,4ms, avg. time = 134,8m
And the same configuration run on 7.4 produces the following results:
Total Time = 63304ms
Avg. min = 540,2ms, avg. max = 687,3ms, avg. time = 682,2ms
I have abandoned the idea of running the test over all columns in version 7.4,
since it was at 7th run after more than an hour or two.
Versions used in testing:
Version: 7.4.0.3 (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: pl-PL
Calc: CL
Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: pl-PL (pl_PL); UI: pl-PL
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
