[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Oct 31 23:24:14 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=128503
m.a.riosv <miguelangelrv at libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |miguelangelrv at libreoffice.o
| |rg
--- Comment #2 from m.a.riosv <miguelangelrv at libreoffice.org> ---
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
--
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/20191031/15e717ea/attachment.html>
More information about the Libreoffice-bugs
mailing list