https://bugs.documentfoundation.org/show_bug.cgi?id=168673
Bug ID: 168673
Summary: COUNTIFS() returns incorrect count with decimal
numbers when matching on last item of area
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 203123
--> https://bugs.documentfoundation.org/attachment.cgi?id=203123&action=edit
Spreadsheet which shows the problem
When building a spreadsheet which uses "COUNTIFS()" on areas with cells of type
time or decimal numbers, COUNTIFS() misses to count an item in some cases.
See attached file for a reproducer with explanations.
In short, if at least the following are true, a matching cell is not counted
correctly:
* The cells contain time-values or decimal numbers
* COUNTIFS() contains a "=" condition
* The condition points to the last cell of the area
Expected results: 1, as the compared cell itself should be matched
Seen results: 0
When using a slightly larger area, it works again. Having the item as last in
the area is required for the issue to be visible.
Tested on the following three versions:
Version: 24.8.7.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: x11
Locale: de-AT (C); UI: en-US
Ubuntu package version: 4:24.8.7-0ubuntu0.24.10.1~bpo24.04.1
Calc: threaded
and
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: x11
Locale: de-AT (de_AT.UTF-8); UI: en-US
Debian package version: 4:25.2.3-2+deb13u2
Calc: threaded
and
Version: 25.8.1.1 (X86_64) / LibreOffice Community
Build ID: 580(Build:1)
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: x11
Locale: en-US (C); UI: en-US
Debian package version: 4:25.8.1-1~bpo13+1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
