https://bugs.documentfoundation.org/show_bug.cgi?id=150734
--- Comment #2 from Colin <that.man.co...@gmail.com> --- Created attachment 182472 --> https://bugs.documentfoundation.org/attachment.cgi?id=182472&action=edit Screen Dump As can be seen, the filter to exclude all blanks had been activated but all the blank lines in that column are still visible. I would expect it to collapse all the blank rows in that column and produce sub-totals as appropriate - just like a pivot table would. In this guise, it's more like an inferior Autofiltered array without the benefit of SUBTOTAL() to include or exclude values in the "hidden" rows. A pivot table should of course consolidate the values into subtotals at the appropriate levels of collapse. -- You are receiving this mail because: You are the assignee for the bug.