[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #15 from ady --- (In reply to Buovjaga from comment #14) > Ok, I checked with linux-64-7.6 and the need for two recalcs stopped with > e7897ce47e415e46eb36687f911a9a4b09ca6b8a > crashtesting: crash in

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #14 from Buovjaga --- (In reply to ady from comment #13) > (In reply to Buovjaga from comment #11) > > > Plot twist: if you do hard recalc twice with attachment 192832 [details], > > you get > > > > 3 > > 3 > > 4 > > The

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #13 from ady --- (In reply to Buovjaga from comment #11) > Plot twist: if you do hard recalc twice with attachment 192832 [details], > you get > > 3 > 3 > 4 The double hard recalc is only needed in certain versions (e.g.

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #12 from Buovjaga --- (In reply to Buovjaga from comment #11) > (In reply to ady from comment #10) > > (In reply to Buovjaga from comment #9) > > > In bug 159858 I got 7674399aac661eb503d7badc53b9a4d68bd9839d as the exact > >

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #11 from Buovjaga --- (In reply to ady from comment #10) > (In reply to Buovjaga from comment #9) > > In bug 159858 I got 7674399aac661eb503d7badc53b9a4d68bd9839d as the exact > > result. > > There must be 2 reasons for the

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #10 from ady --- (In reply to Buovjaga from comment #9) > In bug 159858 I got 7674399aac661eb503d7badc53b9a4d68bd9839d as the exact > result. There must be 2 reasons for the bug(s), instead of just 1 unique commit. Please

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 Buovjaga changed: What|Removed |Added CC||lebry...@gmail.com --- Comment #8

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 ady changed: What|Removed |Added See Also||https://bugs.documentfounda

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 raal changed: What|Removed |Added Blocks||108827 Referenced Bugs:

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 raal changed: What|Removed |Added Keywords||bibisected, bisected Regression By|

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #6 from ady --- tdf#146790 and tdf#151958 seem somewhat related to this, especially when Eike pushed "Disable binary search on sorted cache for current releases" for the later. Quoting Eike: " I disabled it at a central

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #5 from ady --- (In reply to Username from comment #4) > I moved Range1 and Criteria1 and everything was calculated correctly. Thank > you! Just to be clear, that does not solve the bug. A bug is still present, since LO 7.4

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 --- Comment #4 from Username --- I moved Range1 and Criteria1 and everything was calculated correctly. Thank you! -- You are receiving this mail because: You are the assignee for the bug.

[Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING

https://bugs.documentfoundation.org/show_bug.cgi?id=159544 ady changed: What|Removed |Added Summary|Function COUNTIF empty |Function COUNTIFS empty