https://bugs.documentfoundation.org/show_bug.cgi?id=159544
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Windows (All) |All CC| |[email protected] Ever confirmed|0 |1 Version|7.6.4.1 release |7.4.0.3 release Status|UNCONFIRMED |NEW Hardware|x86-64 (AMD64) |All --- Comment #2 from ady <[email protected]> --- I can confirm the problem under the following conditions: * The formula (COUNTIFS in this case) is introduced on a different worksheet than the arguments. * Introducing a similar formula on the same worksheet as where (both Range and Criteria) arguments are located, the result is correct. * If either of the arguments is located on a different worksheet than the formula, the result is incorrect. * When using LO 7.3.1.3 and older, a Hard Recalculate displays the correct result (Sheet2.D6). * A Hard Recalculate does not update the incorrect result when testing with LO 7.4.3.2 and newer versions, including recent 24.8 alpha. > bug. * Showing all rows and re-sorting the Range area (for each and every column) will trigger the correct result in the attached file. * No change when Disabling or Enabling OpenCL; in both cases the incorrect result is displayed in recent LO 24.8 alpha. This is probably a negative consequence of the attempted performance enhancement introduced in LO 7.4: * Improved performance of functions such as COUNTIF, SUMIFS and VLOOKUP, especially with unsorted data tdf#139444 tdf#144777 tdf#146546 (Luboš Luňák, Collabora) IIRC, this is not the first report about negative effects of that change (if indeed this problem is about the same issue). CC'ing Eike. -- You are receiving this mail because: You are the assignee for the bug.
