<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Wrong result of calculation for statistical function Mean in Writer tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89994">bug 89994</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Wrong result of calculation for statistical function Mean in Writer tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89994#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Wrong result of calculation for statistical function Mean in Writer tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89994">bug 89994</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>This is not a bug.
Writer's formulas are using the old Writer formula engine, totally unrelated to
Calc. And in it, every cell used in the MEAN is counted, with a cell not having
a value counted as zero.
(In reply to A (Andy) from <a href="show_bug.cgi?id=89994#c1">comment #1</a>)
<span class="quote">> On the other hand CALC computes it correctly = 2.</span >
Computes what? "MEAN"? There's no such function in Calc. Calc's AVERAGE is a
different function.
Changing the definition of MEAN to mean something different would break
documents where it's currently used, where its current behavior is wanted.
Of course, making it possible to use Calc formulas (something that is possible
with ODF standard, by specifying which namespace is used for the formulas
internally) would make lives much better - but that's a separate problem.
Closing NOTABUG.</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>