Bug 118574 - Calc: show error and other special values at the beginning of the list of automatic filters
Summary: Calc: show error and other special values at the beginning of the list of aut...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: easyHack, needsDevEval
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2018-07-06 11:24 UTC by kabilo
Modified: 2019-01-28 08:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
sorting (186.83 KB, image/jpeg)
2018-09-18 15:36 UTC, kabilo
Details
sorting2 (161.56 KB, image/jpeg)
2018-09-18 15:36 UTC, kabilo
Details
Proposal(s) for UI implemenation (53.58 KB, image/png)
2018-10-04 14:55 UTC, Heiko Tietze
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kabilo 2018-07-06 11:24:14 UTC
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:
Comment 1 Heiko Tietze 2018-07-24 12:43:50 UTC
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.
Comment 2 Eike Rathke 2018-07-24 13:16:23 UTC
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.
Comment 3 Heiko Tietze 2018-09-05 18:44:01 UTC
The use case remains unclear. Feel free to reopen.
Comment 4 Cor Nouws 2018-09-05 19:18:50 UTC
(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 ??
Comment 5 kabilo 2018-09-18 15:36:08 UTC
Created attachment 144985 [details]
sorting
Comment 6 kabilo 2018-09-18 15:36:43 UTC
Created attachment 144986 [details]
sorting2
Comment 7 kabilo 2018-09-18 15:37:40 UTC
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
Comment 8 Cor Nouws 2018-09-18 16:19:15 UTC
(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 :)
Comment 9 Heiko Tietze 2018-09-19 06:12:32 UTC
(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"?
Comment 10 kabilo 2018-09-19 07:32:49 UTC
would it be a solution to change sorting, provided that the column usually contains values of the same type?
alphanumeric
dates
times
numbers
Comment 11 Roman Kuznetsov 2018-10-02 12:19:30 UTC
I don't like this idea. I don't understand how it may be realize
Comment 12 Heiko Tietze 2018-10-04 14:55:18 UTC
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).