[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from David Lynch <david_lynch at blueyonder.co.uk> ---
This makes no diffrence I always have wrong results:                            

no thread                                               

50      0       =COUNTIF(A1,".0")       wrong   50      =REGEX(A1,".0") right
0       1       =COUNTIF(A2,".0")       wrong   #N/A    =REGEX(A2,".0") right
a0      0       =COUNTIF(A3,".0")       wrong   a0      =REGEX(A3,".0") right
57      0       =COUNTIF(A4,".7")       wrong   57      =REGEX(A4,".7") right
57      0       =COUNTIF(A5,".7")       wrong   57      =REGEX(A5,".7") right
7       0       =COUNTIF(A6,".7")       right   #N/A    =REGEX(A6,".7") right
a7      0       =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      0       =COUNTIF(A10,"5.")      wrong   50      =REGEX(A10,"5.")       
right
50      0       =COUNTIF(A11,"5.")      wrong   50      =REGEX(A11,"5.")       
right
a0      1       =COUNTIF(A12,"a.")      right   a0      =REGEX(A12,"a.")       
right

threaded                                                
50      0       =COUNTIF(A1,".0")       wrong   50      =REGEX(A1,".0") right
0       1       =COUNTIF(A2,".0")       wrong   #N/A    =REGEX(A2,".0") right
a0      0       =COUNTIF(A3,".0")       wrong   a0      =REGEX(A3,".0") right
57      0       =COUNTIF(A4,".7")       wrong   57      =REGEX(A4,".7") right
57      0       =COUNTIF(A5,".7")       wrong   57      =REGEX(A5,".7") right
7       0       =COUNTIF(A6,".7")       right   #N/A    =REGEX(A6,".7") right
a7      0       =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      0       =COUNTIF(A10,"5.")      wrong   50      =REGEX(A10,"5.")       
right
50      0       =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/0372c0a8/attachment-0001.html>