[Bug 160904] Remove "= and <>" from "Search criteria = and <> must apply to whole cells"
https://bugs.documentfoundation.org/show_bug.cgi?id=160904 --- Comment #7 from Eike Rathke --- (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.
[Bug 160904] Remove "= and <>" from "Search criteria = and <> must apply to whole cells"
https://bugs.documentfoundation.org/show_bug.cgi?id=160904 --- Comment #6 from Heiko Tietze --- (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? Anyway, how about simply saying "[ ] Enable wildcard in search"? Besides, such an option is weird and I'd expect to rather add wildcards on every search like *win* or "win". -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160904] Remove "= and <>" from "Search criteria = and <> must apply to whole cells"
https://bugs.documentfoundation.org/show_bug.cgi?id=160904 Stéphane Guillou (stragu) changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC||heiko.tietze@documentfounda ||tion.org, ||stephane.guillou@libreoffic ||e.org --- Comment #5 from Stéphane Guillou (stragu) --- Setting to "new" as something needs to be done. Heiko, opinion on the wording? -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160904] Remove "= and <>" from "Search criteria = and <> must apply to whole cells"
https://bugs.documentfoundation.org/show_bug.cgi?id=160904 --- Comment #4 from Eike Rathke --- It's for operators = and <>, also when used in D*() criteria, and when matching for equality like in LOOKUP() or HLOOKUP() and VLOOKUP() with mode=0 (not sorted range lookup), apparently same in XLOOKUP(), and for criteria in *IF() and *IFS() functions. All those also obey the setting if Wildcards or Regex are enabled. Maybe reword to Operators = and <> and search criteria for equality must apply to whole cells -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160904] Remove "= and <>" from "Search criteria = and <> must apply to whole cells"
https://bugs.documentfoundation.org/show_bug.cgi?id=160904 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||113943 CC||79045_79...@mail.ru, ||er...@redhat.com --- Comment #3 from Roman Kuznetsov <79045_79...@mail.ru> --- Eike, do you have some opinion here? Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=113943 [Bug 113943] [META] Options dialog's Calc settings bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160904] Remove "= and <>" from "Search criteria = and <> must apply to whole cells"
https://bugs.documentfoundation.org/show_bug.cgi?id=160904 --- Comment #2 from Mike Kaganski --- Thanks Regina! IMO, removal will solve the problem. It is OK to not use very detailed wording, and let the documentation fill the gaps. But it's bad to have misleading wording :-) -- You are receiving this mail because: You are the assignee for the bug.
[Bug 160904] Remove "= and <>" from "Search criteria = and <> must apply to whole cells"
https://bugs.documentfoundation.org/show_bug.cgi?id=160904 Regina Henschel changed: What|Removed |Added CC||rb.hensc...@t-online.de --- Comment #1 from Regina Henschel --- The option is evaluated in case of Match_mode = 0 (exact match), but is ignored in case of Match_mode = 1 or Match_mode = -1 (approximate match) in XLOOKUP, for example. So simple removing = and <> does not solve the problem. Albeit I have no proposal. -- You are receiving this mail because: You are the assignee for the bug.