AutoFilter dropdown doesn't show (empty) on top of the list with values, but between the last number value and before the first text value.
Steps to Reproduce:
1. Make a column with a headline, filled some cells with numbers, and some celss with text data
2. Click AutoFilter
3. Click on the down arrow of the filter in the headline
The checkbox with (empty) is between the last number value and before the first text value.
The checkbox with (empty) should be on top of the list with values.
User Profile Reset: Yes
Created attachment 170161 [details]
I've checked with previous versions and it has been like this forever.
Could you please explain why should (empty) be on top ?
Because in all other cases, (empty) is always on top - I believed. But now I see, that (empty) is always under number values, but always above text values, also when there aren't mixed values (both number and text).
Thus maybe the bug report should be: (empty) should always be on top of the list of values, both if there are mixed values and if there are only number values (as is the case with text values).
I think, because (empty) is a special 'value' this should always on top. Consider (empty) as null, but now it is sorted on the (.
(In reply to Baggeraar from comment #3)
> Because in all other cases, (empty) is always on top - I believed.
Which other cases?
In case of only text values.
But in fact, (empty) isn't always the first result, but because of the ( it is most time the first result.
As said, because of (empty) is a very special 'result', in my opinion (empty) should always be the first result. Because it is not really (empty) as text string, but it should be considered as null. And that is consequently something different as the real results (numbers or text).
MS Excel place <empty> item always in bottom of the item list.
But I'm not sure that we should move <empty> item to top of the item list. I think it should be always in bottom as it is in MS Excel now
Let's move the "(empty)" entry to the top.
Guess it's STR_EMPTYDATA, sorted with the other content in sc/source/core/data/documen3.cxx at sortAndRemoveDuplicates(). But I have no idea how to move this item on top of the list in an elegant way. And since sortAndRemoveDuplicates() is used a few times across the app, it might also have side-effects.
Note that maybe the same should be the case for '#N/A'.
These are the only two 'special' values, I believe.
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":
tdf#140745 sc AutoFilter: fix placing of "(empty)"
It will be available in 7.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
(empty) is on top now
Version: 126.96.36.199.alpha1+ / LibreOffice Community
Build ID: e96554b67b17f9d3d91b0bb1f29ab0b9cdc43dcb
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US