Data grid: Excel style filter + FormattedValuesFilteringStrategy: sort filter-dialog values

[vilsti]

Question

I want to use a custom formatter to format the values of one of my columns, so that the user sees the formatted values, but they still get sorted by the original data. Additionally i would like to use excel-style filtering. In the filter-dialog of my formatted column, the formatted filter values should be displayed BUT sorted by their unformatted values.

It seems like this is the standard behaviour as implemented in your documentation about formatted values filtering strategy:
https://www.infragistics.com/products/ignite-ui-angular/angular/components/grid/excel-style-filtering#formatted-values-filtering-strategy

Here it seems, that even though the dataType of the column is string, and the formatted value is a string, the filter-values displayed in the Unit Price Category are sorted by the original underlying data, which seems to be of type number.

If my assumption is correct i should be able to copy that behaviour for my 'date' column, without having to resort to a uniqueColumnValuesStrategy. But the filter-dialog values in my implementation get sorted by string/formatted values.

Please tell me if my assumption is correct, then i will provide a working example of my case and a jsFiddle, if you would be so kind to help me

• igniteui-angular version: 12.1
• browser: chrome
• angular CLI: 12.2.5

[github-actions[bot]]

There has been no recent activity and this issue has been marked inactive.

[onlyexeption]

Hello @TomVilsecker,

Your assumption is correct. When using FormattedValuesFilteringStrategy the filter values should be sorted and displayed based on the original data, not the formatter.

Would you mind providing a working example that shows the issue you are describing?