IgniteUI / igniteui-angular

Ignite UI for Angular is a complete library of Angular-native, Material-based Angular UI components with the fastest grids and charts, Pivot Grid, Dock Manager, Hierarchical Grid, and more.
https://www.infragistics.com/products/ignite-ui-angular
Other
568 stars 159 forks source link

Excel Style Filter Dropdown Does Not Display Dates in Descending Order with uniqueColumnValuesStrategy #14333

Open georgianastasov opened 1 month ago

georgianastasov commented 1 month ago

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.

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

1