https://bugs.documentfoundation.org/show_bug.cgi?id=78840
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #4 from Mike Kaganski <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
