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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Thierry BUR <bur.thierry at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bur.thierry at gmail.com

--- Comment #4 from Thierry BUR <bur.thierry at gmail.com> ---
Created attachment 140977
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140977&action=edit
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

-- 
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/20180330/bfa26d5e/attachment.html>