[Libreoffice-bugs] [Bug 131423] New: Function Wizard in Calc allows too many parameters

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131423
           Summary: Function Wizard in Calc allows too many parameters
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stevemfanning.wh at gmail.com

Created attachment 158807
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158807&action=edit
Example of IMPRODUCT function parameters problem

There is a problem with using the Function Wizard to create a call to the
IMPRODUCT function.
(1) The Function Wizard provides for the input of 256 complex numbers.
(2) If you fill up these fields the function gives an error 512 (formula
overflow).
(3) If you clear the 256th field, the function then gives an answer rather than
an error.
See the attached spreadsheet for worked example.

So for this function, the Function Wizard UI is incorrect and should only
provide for the input of 255 parameters.

It is possible that the same problem exists for the following functions:
- AGGREGATE
- GCD_EXCEL2003
- LCM_EXCEL2003
- MULTINOMIAL
- RAWSUBTRACT
- IMSUM

-- 
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/20200319/f4ca8e4b/attachment.htm>