Hi
I am using the formatter for several grid columns to apply formatting on numbers to required decimal places. The problem I am seeing is that if you have multiple values which format to same value they still show independently in the list. So for example if I format 0.0001 and 0.0002 to 2dp then they both become 0.00 but I would see 0.00 appear twice in the list. Each item then only selects it's underlying item
Is there a way to ensure that the excel style filter takes into account the formatter? In it's current state I can't see how using formatters is possible with filtering since the duplicate options referring to different entries make it impossible to use.
Is there any way to get it working so that if things format to same value that they appear once and select all related values?
Thanks
Hey there! Could you please comment also on the actual work item from the product repository.https://github.com/IgniteUI/igniteui-angular/issues/8009
I am interested in a solution for this question.
Thank you Katy, I see the feature request. Feel free to reach us through the issue if there is something else that you want us to address. I've assigned our product owner and the team lead of the team working on the filtering feature in order to discuss it and plan it for the upcoming milestones or the current one.
Actually its not at all a very specific scenario.. this is just one example of many scenarios I am having issues with for formatting with the filters working. Other grids do provide proper support for having the formatted values filtered on so there is definitely a need for it outside of myself. But sure I will raise a feature request for that.
All in all, the desired scenario is very specific and to be honest hardly achievable - Formatting underlying numeric data to string, limiting the filtering list to show it uniquely and later on filter it by the underlying numeric data (in order to show it in the result list).
Feel free to add a feature request for Filtering on the formatted values, it would be a good request worth discussing it.