Summary: | [EDITING] "Not responding" message displayed by Calc on large array selection that has conditional formatting | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | emmanuel.blanchard |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | major | CC: | mhillat, miguelangelrv, stephane.guillou |
Priority: | medium | Keywords: | needsDevEval, perf |
Version: | 7.5.0.3 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 87351, 109139 | ||
Attachments: | file with large array to reproduce crash |
Description
emmanuel.blanchard
2024-04-09 10:04:41 UTC
Created attachment 193582 [details]
file with large array to reproduce crash
It's about 50 seconds of waiting, not a crash, that it's related to the conditional formatting. The "SUBTOTAL" function is forced to calculate 637305 times. Using the "AGGREGATE" function instead of "SUBTOTAL" does not improve it. It's really fast with: ISEVEN(ROW()) I know it's not perfect, but maybe it's not so important in such a large amount of data. I don't know if an improvement could be made for a specific case like this, making the conditional formatting calculations only for the cells on the screen at the end of the selection. Reproduced with attachment, starting in cell A1, in: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: bdf3b5ce49b0e4ee1b4525d344cfb037ef473059 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded LO is completely unusable for a long time. Indeed, without the conditional formatting (can be deleted with Format > Conditional > Manage), no freeze. In 7.4.0.3, unbearably slow to "adapt row height" on fileopen, I assume before the fix for bug 124098 -> marking 7.5 as earliest affected. Setting severity to "major" because of very long freeze. |