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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Apr 5 16:01:22 UTC 2018


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

--- Comment #12 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
(In reply to m.a.riosv from comment #10)
> Please Winfried forgive for not cc.
Absolutely, I wasn't offended in any way, just teasing you ;-)

> 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.

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 ;-)

-- 
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/20180405/d8781962/attachment.html>


More information about the Libreoffice-bugs mailing list