<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:bur.thierry@gmail.com" title="Thierry BUR <bur.thierry@gmail.com>"> <span class="fn">Thierry BUR</span></a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - AGGREGATE COUNTA with hidden rows"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116706">bug 116706</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;">CC</td>
<td>
</td>
<td>bur.thierry@gmail.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - AGGREGATE COUNTA with hidden rows"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116706#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - AGGREGATE COUNTA with hidden rows"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116706">bug 116706</a>
from <span class="vcard"><a class="email" href="mailto:bur.thierry@gmail.com" title="Thierry BUR <bur.thierry@gmail.com>"> <span class="fn">Thierry BUR</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=140977" name="attach_140977" title="Numeric calculation using the result of AGGREGATE()">attachment 140977</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140977&action=edit" title="Numeric calculation using the result of AGGREGATE()">[details]</a></span>
Numeric calculation using the result of AGGREGATE()
Look carefully at the differences between:
- C5 and E5
- C9 and E9
They should give the same result (this is the case under Excel) whatever the
2nd row is hidden thanks to the filter or not.
When you uncheck in the 1rst column the value "XXX", ie., you hide the 2nd
column, the results in B5 and B9 are wrong.
Please double check</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>