https://bugs.documentfoundation.org/show_bug.cgi?id=159858
ady <adylo811...@gmail.com> 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 <adylo811...@gmail.com> ---
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.
