<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 - GEOMEAN gives Err:502 when an argument is zero"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109096">109096</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>GEOMEAN gives Err:502 when an argument is zero
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>drozdik.svk@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134611" name="attach_134611" title="Minimal working example">attachment 134611</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134611&action=edit" title="Minimal working example">[details]</a></span>
Minimal working example
Dear developers,
When computing the geometric mean of numbers containing zero, the answer should
be also a zero. Now the argument checking procedure is too strict and any zero
in the arguments causes an Err:502.
While there is some discussion on whether zero arguments should be allowed:
<a href="https://math.stackexchange.com/questions/91443/geometric-mean-of-a-dataset-containing-0s/91445">https://math.stackexchange.com/questions/91443/geometric-mean-of-a-dataset-containing-0s/91445</a>
I think they definitely should. This would be in accordance with the Wikipedia
definition of geometric mean and also it would make things more consistent. One
can always detect the presence of a zero in arguments, because this is the only
situation in which GEOMEAN should produce a zero.
Thank you for your support!</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>