https://bugs.freedesktop.org/show_bug.cgi?id=78840
Priority: medium
Bug ID: 78840
Assignee: [email protected]
Summary: 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.
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.3.0.0.alpha1
Component: Libreoffice
Product: LibreOffice
Created attachment 99252
--> https://bugs.freedesktop.org/attachment.cgi?id=99252&action=edit
Sample file to test
Currently is not possible search in functions using regular expression in a
case sensitive mode, the finder has their own option for it.
http://ask.libreoffice.org/en/question/33989/case-sensitivity-using-calc-countif-function/
e.g. =COUNTIF(B$1:B$4;"x") find all 'x' in the range no matter their case.
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.
'i' is the flag for the case insensitive mode:
=COUNTIF(B$1:B$4;"(?-i)x")
(?-i) should deactivate case-insensitive mode, so the formula should find only
lower case 'x', but it is not the result.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
