[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