Case-sensitive regular expression search formula in OpenOffice

According to this web page, the SEARCH() regular expressions are, by default, case insensitive. There is an option in the Tools -> Options -> OpenOffice.org Calc -> Calculate dialog to change this.

If you are not seeing case insensitive matches with your REs, check that option.

Recent Questions...