Description

The Infragistics IgxGrid component's excelStyleFilter dropdown for date columns does not display dates in descending order when customized using the uniqueColumnValuesStrategy. The dates continue to appear in ascending order despite the sorting logic provided in the code.

• igniteui-angular version: all
• browser: all

Steps to reproduce

1. Open the provided StackBlitz example.
2. Notice the Date column with the excelStyleFilter enabled.
3. Notice the applied uniqueColumnValuesStrategy for Date column that sort the values in desc order.
4. Click on the filter icon in the Date column header to open the filter dropdown.
5. Observe the order of dates in the dropdown -> asc.

Result

The excelStyleFilter dropdown displays the date values in ascending order instead of the expected descending order.

Expected result

The excelStyleFilter dropdown should display the date values in descending order as specified by the sorting logic in the uniqueColumnValuesStrategy.

Additional Context

This issue persists specifically with date columns.
When using string columns and sorting string values before passing them to the column excelStyleFilter, the values appear in random order rather than the specified order.

Attachments