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.

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.

Summary: Add the regular expression (?ismwx-ismwx: ... ) Flag settings. Evaluate paren...

Status:	UNCONFIRMED

Alias:	None

Product:	LibreOffice
Classification:	Unclassified
Component:	Libreoffice (show other bugs)
Version:	4.3.0.0.alpha1
Hardware:	Other All

Importance:	medium enhancement
Assignee:	Not Assigned
QA Contact:

URL:
Whiteboard:	NeedAdvice
Keywords:

Depends on:
Blocks:

Reported:	2014-05-17 21:35 UTC by m.a.riosv
Modified:	2014-05-21 04:17 UTC (History)
CC List:	1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
Sample file to test (26.62 KB, application/xml) 2014-05-17 21:35 UTC, m.a.riosv	Details
View All

Description m.a.riosv 2014-05-17 21:35:31 UTC

Created attachment 99252 [details]
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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.