<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Incorrect results from regular expresions from COUNTIF (but not from REGEX)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128503">bug 128503</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>miguelangelrv@libreoffice.org
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Incorrect results from regular expresions from COUNTIF (but not from REGEX)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128503#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Incorrect results from regular expresions from COUNTIF (but not from REGEX)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128503">bug 128503</a>
from <span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span></b>
<pre>Please detail at least some of supposed wrong values, COUNTIF does the same as
REGEX for me.
50 1 =COUNTIF(A1;".0") wrong 50 =REGEX(A1;".0")right
0 0 =COUNTIF(A2;".0") wrong #N/A =REGEX(A2;".0")right
a0 1 =COUNTIF(A3;".0") wrong a0 =REGEX(A3;".0")right
57 1 =COUNTIF(A4;".7") wrong 57 =REGEX(A4;".7")right
57 1 =COUNTIF(A5;".7") wrong 57 =REGEX(A5;".7")right
7 0 =COUNTIF(A6;".7") right #N/A =REGEX(A6;".7")right
a7 1 =COUNTIF(A7;".7") wrong a7 =REGEX(A7;".7")right
7a 1 =COUNTIF(A8;".a") right 7a =REGEX(A8;".a")right
ab 1 =COUNTIF(A9;".b") right ab =REGEX(A9;".b")right
50 1 =COUNTIF(A10;"5.") wrong 50 =REGEX(A10;"5.")right
50 1 =COUNTIF(A11;"5.") wrong 50 =REGEX(A11;"5.")right
a0 1 =COUNTIF(A12;"a.") right a0 =REGEX(A12;"a.")right
Version: 6.3.3.1 (x64)
Build ID: f41f4c7f9507aeca13cb9df51f34d80e8ba30a99
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: es-ES (es_ES); UI-Language: en-US Calc:
Version: 6.4.0.0.alpha0+ (x64)
Build ID: 758516295e5f69393bd78bb4af6e7214d48ece0b
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: GL; VCL: win;
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL</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>