https://bugs.documentfoundation.org/show_bug.cgi?id=160081
--- Comment #2 from ady <[email protected]> --- First, the "A:A" entire column notation is usually a source of slowness for Calc. Try changing it to use a delimited range of rows wherever you can. Second, in LO 7.4 some changes involving lookup functions, among other functions, were introduced in order to obtain some potential performance gain. Since then, the changes were (partially) disabled because of incorrect results. ATM, in LO 24.3.1 and 24.8 alpha, we are still awaiting to fully solve the incorrect results, including in functions such as COUNTIFS(). So, if I may, before attempting another potential performance change, as a user I would like to be able to expect correct results (and I am not talking about the typical accuracy issues). Considering that ATM, after more than a year and a half, we still can't really trust Calc, I hope first the known (already reported) problems with these functions get resolved, and some (automated) tests get introduced, before attempting new potential performance gains. In the meantime, I would suggest trying with delimiting the range (instead of full column notation), and perhaps some other ways for you (the user) to optimize formulas, if such edition is available (which is not always the case). -- You are receiving this mail because: You are the assignee for the bug.
