<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Criteria query (COUNTIF() et al) for numeric values broken considering number formats"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144740">144740</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Criteria query (COUNTIF() et al) for numeric values broken considering number formats
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.1 rc
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>critical
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=175286" name="attach_175286" title="Result of this COUNTIF() should be 1 not 2.">attachment 175286</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=175286&action=edit" title="Result of this COUNTIF() should be 1 not 2.">[details]</a></span>
Result of this COUNTIF() should be 1 not 2.
Since the implementation for <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - Standard filters involving "greater than" or "smaller than" (>, <, >=, <=) fail and hide everything"
href="show_bug.cgi?id=142910">bug 142910</a> and the fix for its <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - Filtering does not work with formatted calculated values"
href="show_bug.cgi?id=144253">bug 144253</a>, 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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>