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.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/5708e58ddae44ea7c5f5ad2f76b47be980b53b80 tdf#131360,tdf#131361 (part) 256 arguments
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/2c5b14255f07ae7eba46155558555a1c2011dacf tdf#131360 Adjust number of function parameters
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/9201f2351fa94a6f26375ab084f1e0c882db6001 tdf#131360 Adjust number of function param (2)
All changes needed to address this bug have been checked today and are fixed in the latest LibreOffice Dev 7.0 Help build. Changed status to Resolved / Fixed.