https://bugs.documentfoundation.org/show_bug.cgi?id=146790
--- Comment #12 from ady <[email protected]> --- (In reply to ady from comment #8) > (In reply to Eike Rathke from comment #7) > > What actually is the problem? > > STR: > 1. Open attachment 177583 [details] from comment 2 > 2. [CTRL]+[SHIFT]+[F9] repeatedly until some numeric values in column D have > their background color changed according to their conditional format. > > Step 2 might take several tries, but it will happen eventually. > > The BG color in column D shows repeating values, which in theory would only > happen when there are repeating values in column A too, but it is clearly > not always the case in attachment 177583 [details]. Thus, it would hint at > some problem in COUNTIF(). > > I tried replicating the same situation with column A being integers (instead > of [0...1], and it was clearly less likely to happen. So, is this because > natural accuracy issues? IDK. (FWIW, bug 151958, also related to COUNTIF() > doesn't seem to be related to accuracy.) With a Dev version of LO 25.2 (Build ID: 341f3618866c622fa511f153a1b48621e04ddd17) I was (am) still able to clearly replicate the problematic behavior (10's of Hard Recalculate would be enough). With a Dev version of LO 26.8 dated 2025-12-19 – there is currently no relevant Build ID in LO Dev for Windows in the Version Info – after a 100 of Hard Recalculate, I have not seen the same problematic behavior. Although this does not completely prove that the problem is really solved, it is at least a hint of a possible improvement. Unfortunately, LO Dev 26.8 does not allow me to use the exact same Options that I used with LO Dev 25.2 (e.g. Render is stuck at Skia, instead of "default"), so the comparison is less than ideal. Having said that, at the time I am writing this comment, there are still bugs with COUNTIF() and COUNTIFS() (and some of them are currently being resolved after several years of the initial reports). -- You are receiving this mail because: You are the assignee for the bug.
