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.
Created attachment 159900 [details] FindLowerCase.ods
The case-insensitive behaviour of SEARCH is defined in the OpenFormula [1]. Additionally, starting with v.7.0, regular expressions in functions honor (?-i)/(?i) flags [2] (tdf#78840). So =SEARCH("(?i)[a-z]";A2) should work in v.7.0. Closing WONTFIX, do you agree? [1] http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018874_715980110 [2] http://userguide.icu-project.org/strings/regexp#TOC-Flag-Options
Hi (In reply to Mike Kaganski from comment #2) > Additionally, starting with v.7.0, regular expressions in functions honor > (?-i)/(?i) flags [2] (tdf#78840). Blimey, I had searched (badly then). Thanks a lot, you and Eike, of course. > Closing WONTFIX, do you agree? of course :) Best regards Pierre-Yves