<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Function Wizard in Calc allows too many parameters for "IFS" functions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131657">131657</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Function Wizard in Calc allows too many parameters for "IFS" functions
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>stevemfanning.wh@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=159112" name="attach_159112" title="Screenshot of Function Wizard showing too many parameters for IFS function">attachment 159112</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=159112&action=edit" title="Screenshot of Function Wizard showing too many parameters for IFS function">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>