https://bugs.documentfoundation.org/show_bug.cgi?id=167079
Bug ID: 167079
Summary: [LOCALHELP] Help for LOOKUP function needs improvement
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
The information in the help does not correspond to the information on the Wiki
and is not sufficient. Look at section "If Search vector is a
multi-dimentional..." on the Wiki.
In addition, a link to the Wiki is missing in the help. The other functions on
that page lack a link to the Wiki as well.
The Help page for master is
https://help.libreoffice.org/master/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3159273
The Wiki page is
https://wiki.documentfoundation.org/Documentation/Calc_Functions/LOOKUP/en
Problems:
(A)
current in Help:
SearchVector is the single-row or single-column area to be searched.
That is not correct. Especially for the variant with omitted ResultVector the
SearchVector needs to be a two-dimensional array. But a two-dimensional array
is allowed too if ResultVector is given.
If ResultVector is omitted, the first column (or row, see B) of the array acts
as SearchVector and the last column acts as ResultVector. If ResultVector is
given, then that one is used.
(B)
The help misses the fact, that depending of the column-row count ratio of
SearchVector a column or a row of the array is used for searching, in the case
ResultVector is omitted.
(C)
SearchVector needs do be sorted. But neither Wiki nor Help mention how mixed
content is expected to be sorted. According to specification numbers precede
text.
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1018428_715980110
To get a glue about LOOKUP function, you might look at
https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb
or
https://support.google.com/docs/answer/3256570?hl=en&ref_topic=3105472&sjid=5840723368810875403-EU
--
You are receiving this mail because:
You are the assignee for the bug.
