[Libreoffice-bugs] [Bug 141822] New: Documentation for VLOOKUP should not use word "Criterion" that is a defined term

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141822

            Bug ID: 141822
           Summary: Documentation for VLOOKUP should not use word
                    "Criterion" that is a defined term
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: olivier.hallot at libreoffice.org

VLOOKUP help [1] mentions "Criterion":

> Syntax
> =VLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])

This word "Criterion" has a specific meaning, is defined in ODF [2], and is
used e.g. in SUMIF(S) and the like (see also tdf#131995). On the other hand,
VLOOKUP is documented [3] to use Any [4] as its first argument, and it does not
work with the syntax like "<=1" that is defined for criterion.

The documentation should not use "Criterion" (used as a generic
natural-language word), even combined with other words (like "SearchCriterion"
here) for arguments that are not related to this defined term, to not cause
ambiguity in users.

[1]
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152
[2]
http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#a_4_11_8_Criterion
[3]
http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#VLOOKUP
[4]
http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#a_4_11_13_Any

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210422/bf368ff8/attachment-0001.htm>