https://bugs.documentfoundation.org/show_bug.cgi?id=159544
Bug ID: 159544
Summary: Function COUNTIF empty cells are counted up to the
nearest filled one, regression, EDITING
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Ignores formula results as an empty string
Steps to Reproduce:
1.Create new spreadsheat
2.I add data on the first page, but on the second page I add formulas
3.The cell uses the function
=COUNTIFS($Sheet1.D:D;"";$Sheet1.A:A;A6;$Sheet1.B:B;B6;$Sheet1.C:C;C6) which
incorrectly counts empty cells
4. In version 7.3.7.2 it calculates correctly
Actual Results:
9
Expected Results:
18
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 24; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
