https://bugs.documentfoundation.org/show_bug.cgi?id=160904
--- Comment #7 from Eike Rathke <[email protected]> --- (In reply to Heiko Tietze from comment #6) > (In reply to Mike Kaganski from comment #0) > > Search criteria must apply to whole cells > (In reply to Eike Rathke from comment #4) > > Operators = and <> and search criteria for equality must apply to whole > > cells > > (In reply to Eike Rathke from comment #4) > > ...and for criteria in *IF() and *IFS() functions. > Don't we have "Enable wildcards/regular expressions in formulas" for this? No, they are independent. > Anyway, how about simply saying "[ ] Enable wildcard in search"? Does not suit, as it is neither about wildcards nor about search. > Besides, such an option is weird and I'd expect to rather add wildcards on > every search like *win* or "win". You may find it weird, but the = and <> operators _never_ evaluate wildcards or regex. -- You are receiving this mail because: You are the assignee for the bug.
