For the following Calc functions, the number of parameters specified in the help files does not match the number specified in the Function Wizard: • GCD (should accept up to 255 integers) • LCM (should accept up to 255 integers) • PRODUCT (should accept up to 255 numbers) • SUM (should accept up to 255 numbers) • SUMSQ (should accept up to 255 numbers) • NPV (should accept up to 255 values) • AVEDEV (should accept up to 255 numbers) • AVERAGE (should accept up to 255 numbers) • AVERAGEA (should accept up to 255 values) • COUNT (should accept up to 255 values) • COUNTA (should accept up to 255 values) • DEVSQ (should accept up to 255 numbers) • KURT (should accept up to 255 numbers) • MAX (should accept up to 255 numbers) • MAXA (should accept up to 255 values) • MEDIAN (should accept up to 255 numbers) • MIN (should accept up to 255 numbers) • MINA (should accept up to 255 values) • MODE (should accept up to 255 numbers) • MODE.MULT (should accept up to 255 numbers) • MODE.SNGL (should accept up to 255 numbers) • SKEW (should accept up to 255 numbers) • SKEWP (should accept up to 255 numbers) • STDEV (should accept up to 255 numbers) • STDEV.P (should accept up to 255 numbers) • STDEV.S (should accept up to 255 numbers) • STDDEVA (should accept up to 255 values) • STDEVP (should accept up to 255 numbers) • STDEVPA (should accept up to 255 values) • VAR (should accept up to 255 numbers) • VAR.P (should accept up to 255 numbers) • VAR.S (should accept up to 255 numbers) • VARA (should accept up to 255 values) • VARP (should accept up to 255 numbers) • VARPA (should accept up to 255 values) • AND (should accept up to 255 logical values) • OR (should accept up to 255 logical values) • XOR (should accept up to 255 logical values) • SUMPRODUCT (should accept up to 255 arrays) • CHOOSE (should accept up to 255 values) • CONCATENATE (should accept up to 255 text strings) It is assumed that the Function Wizard is correct and that therefore the help files should be corrected. See also Bug 131360.
Eike, Olivier, your opinions?
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
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/ea72cf580abb767685e2fa6d9e5b9ef895eed06b tdf#131361 Correct upper limit to 255
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/daf2f20d7b63e1fda11b3e28522ce8a3a4b0c067 tdf#131361 Correct param's GCD, LCM, PRODUCT
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/dac90072fecdfa76352153616f102d3229b5512e tdf#131361 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/93c454f904a11777c934250a46ba6d933d2130c7 tdf#131361 Adjust number of function parameters (2)
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/e22ee2eda6415961d879f58407bf59604e46dbd3 tdf#131361 Adjust number of function parameters (3)
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.