Description: When I select a large array (about 70 colons and 11000 lines with data) the not responding message is displayed on top of the window. If I do anything else, like a click on a menu item, Libreoffice crash. I'm doing this selection with keyboard (CTRL+SHIFT+arrows). Steps to Reproduce: 1.Open a file with very large array issued from opendata 2.Select the array with CTRL+SHIFT+right arrow and CTRL+SHIFT+bottom arrow 3.Click everywhere Actual Results: Crash Expected Results: not crash Reproducible: Always User Profile Reset: No Additional Info: nothing else
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.