[Libreoffice-bugs] [Bug 116706] AGGREGATE COUNTA with hidden rows

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116706

--- Comment #10 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Please Winfried forgive for not cc.

In the attachment of my comment #5,
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180404/3830836e/attachment.html>