[Libreoffice-bugs] [Bug 131361] New: Calc functions with incorrect numbers of parameters specified in Help files

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131361

            Bug ID: 131361
           Summary: Calc functions with incorrect numbers of parameters
                    specified in Help files
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stevemfanning.wh at gmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200315/d5844023/attachment.htm>