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
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