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@lists.freedesktop.org
Reporter: bur.thie...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
