Created attachment 79853 [details]
MATCH behavior on Sheet1 is incorrect.
Using the MATCH function when searching for text containing brackets results in #N/A.
There is an attached spreadsheet demonstrating the issue.
On Sheet1, in A2:A4 there is the text (without quotes) "abc" "b[c]a" and "cab" respectively. MATCH(A3,A2:A4,0) results in #N/A. The expected result is 2. However, on Sheet2, A3 was replaced with "bca" and it successfully returns 2.
This was tested only on Ubuntu 12.04 with LibreOffice 22.214.171.124.
confirm reproducible on LO 126.96.36.199 (Win7 32bit)
turn off "Allow regular expressions in formulas".
See the Help for "Regular expressions".