https://bugs.documentfoundation.org/show_bug.cgi?id=160596
m_a_riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #2 from m_a_riosv <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
