I have a grid that displays a list of values formatted with rounding applied...
I.E. in the grid the value behind the scenes is 1234.51 but the actual display value is $1,235
When applying a user entered filter, they're typing in to filter for "$1,235", and of course the filter returns no records.
Is there a way to make the filter apply to the displayed value rather than the underlying value?
Thanks
Chadwick
PS Below is what I'm using to apply:
RecordFilterDescriptor recordFilterDescriptor = new RecordFilterDescriptor(tableCellIdentity.Column.Name,customFilterDialog.FilterString);
where customFilterDialog.FilterString is something like [a] = 1235
