https://bugs.documentfoundation.org/show_bug.cgi?id=144740
Bug ID: 144740
Summary: Criteria query (COUNTIF() et al) for numeric values
broken considering number formats
Product: LibreOffice
Version: 7.2.0.1 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 175286
--> https://bugs.documentfoundation.org/attachment.cgi?id=175286&action=edit
Result of this COUNTIF() should be 1 not 2.
Since the implementation for bug 142910 and the fix for its bug 144253, numeric
criteria query for interpreter functions are utterly broken in that they take
the number format into account as well, which was meant to be implemented for
filtering, AutoFilter etc., but the comparing functions are shared and MUST NOT
do such for the interpreter functions.
--
You are receiving this mail because:
You are the assignee for the bug.
