https://issues.apache.org/ooo/show_bug.cgi?id=122358
Rob Weir <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Resolution|--- |INVALID --- Comment #2 from Rob Weir <[email protected]> --- COUNTIF() searches for the given string in the given range. This might be at the start of the string, or in the middle. So when you search for "Me" it is also matches on those characters in "Memoirs of Geisha" or "Metamorphoses". You can control this behavior via the Tools/Options/OpenOffice.org Calc/Calculate dialog: Enable Search Criteria = and <> must apply to whole cells Disable Enable Regular Expressions in formulas I'm closing this defect report since this is not really a bug -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
