Bug 141822 - Documentation for VLOOKUP should not use word "Criterion" that is a defined term
Summary: Documentation for VLOOKUP should not use word "Criterion" that is a defined term
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Olivier Hallot
Whiteboard: target:7.2.0
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
Reported: 2021-04-22 05:50 UTC by Mike Kaganski
Modified: 2021-04-27 11:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2021-04-22 05:50:21 UTC
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
Comment 1 Commit Notification 2021-04-27 11:03:36 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":


tdf#141822 Rename parameter for standard compliance