https://bugs.documentfoundation.org/show_bug.cgi?id=170388
--- Comment #2 from ady <[email protected]> --- FWIW... In attachment 205087 please be aware that the actual (incorrect) result depends on the version of Calc. For instance, older versions would provide 0 (zero) as the result, whereas newer ones would return 1 (one), both results being incorrect. IOW, in order to fully test this case (e.g. to add a unit test of sorts), it is not enough to see that the initial number is incorrect, but rather an additional step is needed (otherwise, someone might think that this is an inherited bug). For instance: 1. Open attachment 205087. 2. Recalculate Hard (i.e. press Control-Shift-F9); note that cells A3 and A6 still show the incorrect result. 3. In cell B9 (the specific cell address is relevant for the test): 3.1 Type-in =ISBLANK(B2:D2) and then press Control-Shift-Enter (CSE) (please note the range argument). 3.2 Press Control-Shift-F9 (Recalculate Hard); note that cells A3 and A6 still show the incorrect result. 4. Select the cell's range B9:D9. 5. Press Control-C (copy). 6. On cell C10: 6.1 (the specific cell address is relevant for the test), Control-V (paste). 6.2 Control-Shift-F9; note that cells A3 and A6 still show the incorrect result, but (probably) different than before. 7. On cell D11, repeat steps 6.1 and 6.2. 8. On cell E12, repeat steps 6.1 and 6.2. After Recalculate Hard, this is the first time that the result is as expected. 9. On cell E13, repeat steps 6.1 and 6.2. After Recalculate Hard, the correct result should still be displayed. This procedure shows the _current_ (2026-01-20) issue, to differentiate it from older cases in which COUNTIF* would also show incorrect results. -- You are receiving this mail because: You are the assignee for the bug.
