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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116706
           Summary: AGGREGATE COUNTA with hidden rows
           Product: LibreOffice
           Version: 6.0.1.1 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bur.thierry at gmail.com

Description:
When hidding rows in a structured table, AGGREGATE() doesn't behave correctly.

There is a formula that permits to check wether a row is hidden or not by
counting the current row cell of a range fully populated:
=--(AGGREGATE(3; 5; [@[Dummy filled]) > 0).

When hidding the row, the count function shoud return 0 and the test return
FALSE. One can easily check this by filtering the filled column (rejecting one
row, see example file).

A similar formula with SUBTOTAL behaves correctly

Steps to Reproduce:
1. Open attached file
2. Filter/unfilter one row (for exemple the 2nd row vy unchecking XXX in the
filter of the A column
3. See the result of the aggregate function that is copied below in B5. 

Actual Results:  
B5 is TRUE

Expected Results:
B5 should be FALSE


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: fr
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36 Edge/15.15063

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