[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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to m.a.riosv from comment #0)
> In the icu regular expression operators
> (http://userguide.icu-project.org/strings/regexp) there is:
> 
> (?ismwx-ismwx: ... ) Flag settings. Evaluate the parenthesized expression
> with the specified flags enabled or -disabled.
> (?ismwx-ismwx) 	Flag settings. Change the flag settings. Changes apply to
> the portion of the pattern following the setting. For example, (?i) changes
> to a case insensitive match.
> 
> But those seem don't work. I guess they aren't implemented.

They are implemented. It's just the CountIf disables case sensitivity for
unclear reason (see "Never case-sensitive" comment in ScInterpreter::ScCountIf
in sc/source/core/tool/interpr1.cxx): the OpenFormula does not impose the
insensitivity restriction on the function (unlike e.g. MATCH: cf. 6.13.9 and
6.14.9 at [1]).

There's a new REGEX function [2] implemented by Eike for 6.2, which doesn't
disable the case sensitivity. Of course, using it with COUNTIF is more involved
than plain regex in COUNTIF criteria.

I don't think that any new option in calculation settings is required. Since
the standard does not impose the restriction on the function, it might simply
be considered insensitive by default, and when regex is used, it may honor the
advanced regex options mentioned in comment 0.

[1] http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html
[2] https://help.libreoffice.org/6.3/en-US/text/scalc/01/func_regex.html

-- 
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/20191219/c0932bcd/attachment-0001.htm>