<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - UI: wrong number of selected rows in status bar when rows are filtered" href="https://bugs.documentfoundation.org/show_bug.cgi?id=84517#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - UI: wrong number of selected rows in status bar when rows are filtered" href="https://bugs.documentfoundation.org/show_bug.cgi?id=84517">bug 84517</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>I am experiencing the same (<a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED DUPLICATE - Autofilter produces inconsistent summary data when filtered results are marquee selected" href="show_bug.cgi?id=121551">bug 121551</a>) but also, noted that if the sheet contains a couple of thousand rows and 40+ columns then the value summaries -total, average- of the selected rows also appear to be calculated on the total value of all the cells in the unfiltered range. As noted, cutting and pasting to a new "unfiltered" location, sheet, document, produces the correct summaries. The summaries are also impacted if the filtered rows are sorted on one of the other filters. Sorting on the actual filtered column then rectifies the summaries. There are some fairly definitive screen images attached to that closed report. It would also surprise me if this is not a cause of the printing anomaly whereby the "end of page" for the printed output is "erratic" - some pages in the multi-page document will contain perhaps 10 lines whilst others may be only 1 or 2 lines short of a full page and not quite so noticeable. If it's of any assistance, I can provide a completely anonymised sheet with 3000+ rows of actual data, where the personal information is encrypted - but still sortable. Definitely no GDPR issues and masses of permutation possibilities.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>