[Libreoffice-bugs] [Bug 84517] UI: wrong number of selected rows in status bar when rows are filtered

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 21 07:42:56 UTC 2018


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

--- Comment #13 from Colin <that.man.colin at gmail.com> ---
I am experiencing the same (bug 121551) 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.

-- 
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/20181121/6c3cd358/attachment.html>


More information about the Libreoffice-bugs mailing list