<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"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131423">131423</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Function Wizard in Calc allows too many parameters
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</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=158807" name="attach_158807" title="Example of IMPRODUCT function parameters problem">attachment 158807</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=158807&action=edit" title="Example of IMPRODUCT function parameters problem">[details]</a></span>
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</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>