Summary: | Remove "= and <>" from "Search criteria = and <> must apply to whole cells" | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Mike Kaganski <mikekaganski> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | 79045_79045, erack, heiko.tietze, rb.henschel, stephane.guillou |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=131995 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 113943 |
Description
Mike Kaganski
2024-05-02 07:55:44 UTC
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. 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 :-) Eike, do you have some opinion here? 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 Setting to "new" as something needs to be done. Heiko, opinion on the wording? (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". (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. |