https://bugs.documentfoundation.org/show_bug.cgi?id=131360
Bug ID: 131360
Summary: Syntax statements in Help files that do not specify
number of parameters allowed for Calc functions
Product: LibreOffice
Version: 6.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
For the following Calc functions, the syntax statement in the relevant help
file does not specify the number of parameters that can be passed to the
function (as defined in the Function Wizard):
(a) AGGREGATE (should accept up to 256 references)
(b) GCD_EXCEL2003 (should accept up to 256 numbers)
(c) LCM_EXCEL2003 (should accept up to 256 numbers)
(d) MULTINOMIAL ( should accept up to 256 numbers)
(e) RAWSUBTRACT (should accept up to 256 subtrahends)
(f) SUMIFS (should accept up to 255 range / criteria pairs)
(g) AVERAGEIFS (should accept up to 255 range / criteria pairs)
(h) COUNTIFS (should accept up to 255 range / criteria pairs)
(i) MAXIFS (should accept up to 255 range / criteria pairs)
(j) MINIFS (should accept up to 255 range / criteria pairs)
(k) IFS (should accept up to 255 test / result pairs)
(l) SWITCH (should accept up to 255 value / result pairs)
(m) GETPIVOTDATA (should accept up to 255 field / item parameters)
(n) CONCAT (should accept up to 255 text items)
(o) TEXTJOIN (should accept up to 255 text items)
(p) IMPRODUCT (should accept up to 256 complex numbers)
(q) IMSUM (should accept up to 256 complex numbers)
Note: There are other Help entries which include syntax statements that specify
an incorrect number of parameters for Calc functions. These are covered by a
separate bug.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
