<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - AGGREGATE COUNTA with hidden rows" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116706#c12">Comment # 12</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - AGGREGATE COUNTA with hidden rows" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116706">bug 116706</a> from <a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> Winfried Donkers</a> <pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=116706#c10">comment #10</a>) > Please Winfried forgive for not cc. Absolutely, I wasn't offended in any way, just teasing you ;-) > In the attachment of my <a href="show_bug.cgi?id=116706#c5">comment #5</a>, > C7=AGGREGATE(3;B7;$Feuil1.$A3) => l, bad. (red) > C11==AGGREGATE(3;B11;$A3:$A3)=> 0, good. (green) > B7=B11=5 (5 => Ignore only hidden rows), row 3 is hidden. > what makes the different it's beetwen $A3 ($Feuil1. doesn't matter) and > $A3:$A3, doesn't work with a single cell but so with a range. Ah, yes, finally I see the problem. AGGREGATE(3;5;A2:A4) works fine, but AGGREGATE(3;5;A3) doesn't. If I can find the cause I'll assign this bug to myself and fix it. After all, chances are that I introduced the bug as well ;-)</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>