[Libreoffice-ux-advise] [Bug 149984] Add sortable counts to AutoFilter drop down

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to Pierre Fortin from comment #6)
> Created attachment 181265 [details]
> Mock up of suggestion

Indeed, this would be acceptable UX-wise.

Foo          (12) = (COUNTIF(<RANGE>,"Foo")
Bar         (276)
Baz           (3)
Very long... (42)

Added the brackets to more clearly indicate the count, not necessarily a good
idea. And ellipsis to cover for long names.

Question is if such pre-processing is cheap or has serious impact on
performance.

> Agreed. BTW, what does "Filter by Condition>Top 10" really mean?  :)
https://help.libreoffice.org/7.3/en-US/text/scalc/01/12040100.html

1,1,1,2,2,2...,10,20,30...100 shows 10..100 with TOP10 not 1,2... with the
highest rank. An alternative to your idea could be to have RANK10 that filters
for the highest countif() items.

-- 
You are receiving this mail because:
You are on the CC list for the bug.