[Libreoffice-bugs] [Bug 131360] New: Syntax statements in Help files that do not specify number of parameters allowed for Calc functions

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: stevemfanning.wh at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200315/d63c0c61/attachment-0001.htm>