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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #9 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
I may miss something important here but:
1. AGGREGATE is only introduced with version 4.3.0, so how can this occur with
versions 4.1.x and 4.2.x?
2. AGGREGATE has an argument 'option'. In  attachment 140975 this argument has
value 5, meaning that _hidden_rows_are_to_be_ignored_. 

One of the main differences between AGGREGATE and SUBTOTAL is this
option-argument.

The description mentions steps to reproduce, but in step 2 it says
filter/unfilter  one row and in actual and expected results it doesn't say
whether these results are for hidden or for non hidden row.
I cannot (yet) reproduce an erroneous result for AGGREGATE.
Could someone explain with step by step instructions how to reproduce an
incorrect result?

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