[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 --- Comment #8 from Buovjaga --- (In reply to Buovjaga from comment #6) > (In reply to ady from comment #4) > > Created attachment 192832 [details] > > Example with results of several LO versions > > > > This file shows the most simple case of the problem, with the results of the > > same formulas calculated with diverse versions of LO Calc. > > > > Since this is the simplest case, I would suggest setting this report as the > > main one, and the others as dupes of this report. > > I wonder what explains the different result compared to my example file? Aah, Heisenberg's revenge: try doing hard recalc *twice*! -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 --- Comment #7 from ady --- (In reply to Buovjaga from comment #6) > I wonder what explains the different result compared to my example file? In attachment 192832, please note the result for LO 7.4.3.2 for each of the formulas, and compare the results with the other versions. Such comparison shows that there are at least 2 separated issues – I am _guessing_ that it could be possibly related to the temporal patches in tdf#151958, but yet to be proven. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 --- Comment #6 from Buovjaga --- (In reply to ady from comment #4) > Created attachment 192832 [details] > Example with results of several LO versions > > This file shows the most simple case of the problem, with the results of the > same formulas calculated with diverse versions of LO Calc. > > Since this is the simplest case, I would suggest setting this report as the > main one, and the others as dupes of this report. I wonder what explains the different result compared to my example file? -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 --- Comment #5 from ady --- (In reply to Buovjaga from comment #3) > 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. There must be 2 reasons for the bug(s), instead of just 1 unique commit. Please see attachment 192832 that proves it. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 --- Comment #4 from ady --- Created attachment 192832 --> https://bugs.documentfoundation.org/attachment.cgi?id=192832=edit Example with results of several LO versions This file shows the most simple case of the problem, with the results of the same formulas calculated with diverse versions of LO Calc. Since this is the simplest case, I would suggest setting this report as the main one, and the others as dupes of this report. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 Buovjaga changed: What|Removed |Added Status|NEW |RESOLVED Keywords|bibisectNotNeeded |bibisected, bisected Resolution|--- |DUPLICATE --- Comment #3 from Buovjaga --- (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.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org --- Comment #2 from Buovjaga --- Created attachment 192831 --> https://bugs.documentfoundation.org/attachment.cgi?id=192831=edit Example file -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 Buovjaga changed: What|Removed |Added Keywords||bibisectNotNeeded, ||regression -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159858] COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
https://bugs.documentfoundation.org/show_bug.cgi?id=159858 ady changed: What|Removed |Added Hardware|x86-64 (AMD64) |All See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||9544, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||1958 CC||er...@redhat.com, ||xiscofa...@libreoffice.org Severity|minor |normal Ever confirmed|0 |1 Status|UNCONFIRMED |NEW Version|7.5.0.1 rc |7.4.0.3 release OS|Windows (All) |All Blocks||108253 --- Comment #1 from ady --- 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. 3. =COUNTIFS(A2:H2;"x";A1:H1;"=") overcomes the failure, perhaps just by chance. IOW, when the empty cells are evaluated last, the result seems correct (similar to tdf#159544). CC'ing Eike and Xisco. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108253 [Bug 108253] [META] Calc cell formula bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
