<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;">Status</td>
<td>RESOLVED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</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#c3">Comment # 3</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>Hi Miguel-Angel,
You might have checked this too quickly, it's not just a "format matter".
To convince you, I slighly modified the file with a SUMPRODUCT computation that
uses the "Visible" column as weight (normally 1 for visible rows and 0 for
hidden rows).
The SUMPRODUCT computation should result in 3 when both rows are visible, and
result in 2 when 2nd row is hidden. But it returns 3 instead of 2.
When all rows are visible, yellow and green cells are the same.
And after I've hidden the 2nd row, the results are no more the same. The green
ones (with SUBTOTAL) are the wished good results :
Please doublecheck the herejoined file (V2)</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>