https://bugs.documentfoundation.org/show_bug.cgi?id=159858
Bug ID: 159858
Summary: COUNTIFS doesn't count empty cells at the end of the
1st range if there is non-empty cells before
Product: LibreOffice
Version: 7.5.0.1 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: lebry...@gmail.com
Description:
When using COUNTIFS on exactly 2 range and counting the number of empty cells
on the 1st range, if the 1st on contains at least one not empty cell then all
empty cells after the last not empty cells are not taken in account.
Steps to Reproduce:
1. Fill :
1st row : A1, x; B1, ; C1, x ; D1, ;
2nd row : A2, x; B2, x; C2, x ; D2, x;
2. In A3 : =COUNTIFS(A1:D1,"=",A2:D2,"=x")
Actual Results:
1
Expected Results:
2
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.5.2 (X86_64) / LibreOffice Community
Build ID: 38d5f62f85355c192ef5f1dd47c5c0c0c6d6598b
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (fr_FR); UI: fr-FR
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
