[Libreoffice-bugs] [Bug 78840] Add the regular expression (?ismwx-ismwx: ... ) Flag settings. Evaluate parenthesized expression with specifics flags enabled or -disabled. To have a case sensitive mode in functions using regular expressions.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #14 from Mike Kaganski <mikekaganski at hotmail.com> ---
By the way, this behaviour makes regex with (?-i) work wrong:

> A1   q
> A2   Q
> A3   =COUNTIF(A1:A2; "(?-i)q")

gives 2

> A1   q
> A2   Q
> A3   =COUNTIF(A1:A2; "(?-i)Q")

gives 0

because contents of both cells made lowercase "q" before being passed to regex
engine to test against regex which is explicitly set case-sensitive.

-- 
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/20191221/bd04b75f/attachment.htm>