[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
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|NOTABUG                     |---
     Ever confirmed|0                           |1

--- Comment #3 from Thierry BUR <bur.thierry at gmail.com> ---
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)

-- 
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/3adc2911/attachment.html>