[Libreoffice-bugs] [Bug 144740] New: Criteria query (COUNTIF() et al) for numeric values broken considering number formats

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: erack at redhat.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210926/e658bb1b/attachment.htm>