Description: Would it be possible to display values of type 'Error:', '#N/A', '#DIV/0!', 'empty' always at the beginning of the filter list of values? Actual Results: the 'empty' value in the list of AutoFilter is at the top for text values and at the end for numeric values Expected Results: Reproducible: Always User Profile Reset: No Additional Info:
What is your use case for that? I suspect you have a long list and want to abuse the filter to find non-numeric fields.
Just for explanation: the listed order is dates times numbers alphanumeric The (empty) value is sorted to the top of alphanumeric values because it is an empty text but just displayed as "(empty)", and you usually see #error values sorted before other text within alphanumeric because of the # number sign and no other special character (like '(' or '!') starting other text, but not because they would have any special position.
The use case remains unclear. Feel free to reopen.
(In reply to Heiko Tietze from comment #1) > What is your use case for that? I suspect you have a long list and want to > abuse the filter to find non-numeric fields. Not sure if the word 'abuse' is righteous here ;) It may be a reasonable use to easily spot anomalies in a filter. But... @kabilo ??
Created attachment 144985 [details] sorting
Created attachment 144986 [details] sorting2
I need to check if there are errors in the cells. The display at the beginning of the filter would be clearer than at the end of the list. Thanks
(In reply to kabilo from comment #7) > I need to check if there are errors in the cells. The display at the > beginning of the filter would be clearer than at the end of the list. Thanks At the end or in between... I see this as a valid request for enhancement. thanks for your reply :)
(In reply to kabilo from comment #7) > I need to check if there are errors in the cells. The display at the > beginning of the filter would be clearer than at the end of the list. That's what I expected. And I still dislike the idea of special sorting algorithm, which is related to text and error-prone. So how about a filter numeric/non-numeric next to "Top 10"... "Non Empty"?
would it be a solution to change sorting, provided that the column usually contains values of the same type? alphanumeric dates times numbers
I don't like this idea. I don't understand how it may be realize
Created attachment 145382 [details] Proposal(s) for UI implemenation We discussed the proposal in the design meeting. "Errors" are not the optimal category filtering but perhaps alphanumeric in contrast to numeric. The mockup show this and takes into account that more predefined filters might be requested, such as Date/Time, which could be solved in a more sophisticated solution (right image).