There seems to be a bug in the Match Function, especially when the cells to be checked contains a “(” “)” “[” “]”
I was ready to upload a screenshot of a test, but OMG … karma needed.
How pity is the en.libreofficeforum.org shutdown ?
a a 1
(a (a #N/A
a) a) #N/A
(a) (a) 1
[a [a #N/A
a] a] 6
[a] [a] 1
@a @a 8
a@ a@ 9
a a #N/A
a a a a 11
{a {a 12
a} a} 13
{a} {a} 14
'=MATCH(Brow;$A:$A;0)It’s not a bug, it’s a feature 
Disable regular expressions under Tools - Options - Calc - Calculate, or escape regular expression meta characters in the search term.
Thanks, the disable did the job, but still I consider it very strange. The cells I compare are text-cells not formulae, so they should be used as such. The RegExp should only relate to formulae, not data (content)
@wquatan: “The RegExp should only relate to formulae, not data (content).”
Would you mind to tell us why? Content of type text and results of ‘FormualResultType’ text should be handled in the same way, IMO. They both answer TRUE if asked =ISTEXT(*This*). Many of my solutions working with RegEx relied on this behaviour.