[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
Fri Nov 1 14:00:10 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=128503

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #5 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
with 

Version: 6.3.3.2 (x64)
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: 

i have following results:

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

-- 
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/20191101/525c10c4/attachment.html>


More information about the Libreoffice-bugs mailing list