Excel-style filtering search by numeric column like Percent is display-based

[kdinev]

Description

When I have a numeric percent column in an igx-grid and I have ESF turned on, searching column values happens by formatted display value, when it has to has to happen by numeric display value [with display factor applied].

• igniteui-angular version: 21.1.x
• browser: all

Steps to reproduce

1. Run the dev demos
2. Open gridPercentage demo
3. Open the ESF drop down on the Reorder Level column
4. Seach for 2500

Result

No results are found. In order to see 2500%, I need to search for 2,500%, which is the formatted locale value.

Expected result

The record showing 2500% should be shown.

Attachments