[Libreoffice-bugs] [Bug 132380] New: Tools> Options> Calc> Calculate> Case sensitive should be used by functions handling regular expressions

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132380
           Summary: Tools> Options> Calc> Calculate> Case sensitive should
                    be used by functions handling regular expressions
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pierre-yves.samyn at laposte.net

Description:
Hi

With Edit> Find & Replace we can search: [a-z], tick "Match case" & "Regular
expressions" then find all to select cells containing lowercase letters.

SEARCH function supports regular expressions but does not use Tools> Options>
Calc> Calculate> Case sensitive. 

So SEARCH function does not distinguish between upper and lower case letters.

It is therefore impossible to do the same search as above:

=SEARCH("[a-z]";A2)

As workaround we have to do =NOT(EXACT(UPPER(A2);A2))

Steps to Reproduce:
1. Open FindLowerCase.ods attached
2. See B3 result is 1
3. Tick or Untick "Tools> Options> Calc> Calculate> Case sensitive" according
to the status of the option
4. See B3 result 

Actual Results:
1

Expected Results:
#VALUE (no lowercase in A3)


Reproducible: Always


User Profile Reset: No



Additional Info:
All functions (e.g. COUNTIF) that support regexp should also use this option.

-- 
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/20200424/16f0d2f6/attachment-0001.htm>