https://bugs.documentfoundation.org/show_bug.cgi?id=159858
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Keywords|bibisectNotNeeded |bibisected, bisected Resolution|--- |DUPLICATE --- Comment #3 from Buovjaga <[email protected]> --- (In reply to ady from comment #1) > This has been a problem since LO 7.4. > > This problem is related to tdf#151958 and tdf#159544, among others. This > tdf#159858 shows a simple case to test for the bug(s). > > For an example similar to that described in this tdf#159858 comment 0, using > semicolon as argument separator: > > |A|B|C|D|E|F|G|H > 1|x||x||x||x| > 2|x|x|x|x|x|x|x|x > > where "||" means an empty cell, and; > _ |A|B|C|D|E|F|G|H represent the respective column headers, and; > _ the initial "1" and "2" in each line represent the respective row headers. > > > 1. > =COUNTIFS(A1:H1;"=";A2:H2;"x") > > fails since LO 7.4 up until recent 24.8 alpha. > > > 2. > =COUNTIFS(A1:H1;"=";A2:H2;"=x") > > fails in (only) part of the range of versions, including recent LO 24.8 > alpha. With the example file, result for both after hard recalc (Ctrl+Shift+F9) is 3 while it should be 4 starting at commit 7674399aac661eb503d7badc53b9a4d68bd9839d. Tested with linux-64-7.4. So this is actually a dupe of bug 159544. *** This bug has been marked as a duplicate of bug 159544 *** -- You are receiving this mail because: You are the assignee for the bug.
