[Libreoffice-bugs] [Bug 131657] New: Function Wizard in Calc allows too many parameters for "IFS" functions

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131657
           Summary: Function Wizard in Calc allows too many parameters for
                    "IFS" functions
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                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 159112
  --> https://bugs.documentfoundation.org/attachment.cgi?id=159112&action=edit
Screenshot of Function Wizard showing too many parameters for IFS function

For the six Calc functions SUMIFS, AVERAGEIFS, COUNTIFS, MAXIFS, MINIFS, and
IFS, the Function Wizard provides text boxes for entering either 510 or 511
parameters. I've attached a screenshot showing this.

It is not possible for that many parameters to be processed by these functions
and the number of text boxes should be reduced to reflect the actual limit.

-- 
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/20200329/caf80d5f/attachment-0001.htm>