[Bug 161934] "Top 10" item in Autofilter filter drop-down is ambiguous

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from ady <adylo811517 at gmail.com> ---
(In reply to Eyal Rozenberg from comment #0)
> * "The 10 rows with the highest value"

I sincerely ask... How/why would that be the meaning? This is within the
context of AutoFilter, right? When you select one (or several) items, is the
expected behavior clear? Are the specific row numbers in such case relevant? Is
there any reason for "Top 10..." to behave differently? If the item were to be
"Top 3...", would you understand it to be the same (highest) value that was
first found 3 times in the list, and then only show those 3 (first listed) rows
with the same highest value?


> * "All rows with any of the 10 highest values"

Well, yes. Just by trying it once, users should be able to understand the
result quite immediately, don't they?

> * "The 10 rows at the top of the table" ... ok, a bit of stretch, but still.

Context matters. This is in the context of AutoFilter. Showing a "podium" (of
10) refers to a rank, as with any competition.

If a user needs to show the first 10 rows, whichever the value they have, then
the specific column in which the "Top 10..." filter is used is relevant. For
instance, a column could be an index, and showing either the "Top 10" or the
"Bottom 10" would be relevant for such filter on that column.

The AutoFilter on a specific column works according to the values in that
column – there is the issue of the display format vs the cell's internal value,
but that's a different unrelated thing.

In the context of the AutoFilter feature, I don't see the potential confusion,
and even if there was (e.g. for newbies that don't have experience with this
specific filter), one simple try/test should be enough to clarify its
intention.

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