https://bugs.documentfoundation.org/show_bug.cgi?id=143585
Bug ID: 143585
Summary: "Calling Calc Functions" help examples should use
names following respective functions' help topics
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CC: olivier.hal...@libreoffice.org
"Calling Calc Functions" help page [1] has an example for VLOOKUP, which passes
the four arguments expected by the spreadsheet function using names that don't
follow the names used in the VLOOKUP spreadsheet function help [2]: namely, [2]
uses names "SearchCriterion", "Array", "Index", while [1] uses "item",
"InRange", "FromCol" for the same. Non-English speakers will not recognize the
semantical connection (which itself is poor). Of course, Array is itself a
BASIC function name, so the used name should be similar but not identical; but
the other names could be used as is.
Specifically, the question arose on a Russian user forum [3]. Users do not
necessarily draw connections between arguments to Array function, and arguments
to the called spreadsheet function. (This itself could be explicitly mentioned,
and maybe the reference to the service could have a link to api.libreoffice.org
by the way.)
[1]
https://help.libreoffice.org/7.2/en-US/text/sbasic/shared/calc_functions.html?&DbPAR=BASIC
[2]
https://help.libreoffice.org/7.2/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152
[3] https://forumooo.ru/index.php/topic,8715.60/msg,59125.html
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
