I have a dropdown limit to list column which has a code value and a display value. So say 1 maps to Val1, 2 maps to Val2, and so on. In the grid I see Val1, Val2 - and in the data is stored 1,2 and so on.
If I group on that column, it is grouping on the data value - so it will say "SomeColumn: 1 (2 items)". It should really say "SomeColumn: Val1 (2 items)".
Is there any way to do this? The codes are meaningless to the users, the users need to see the display values.
I think I found the bug: the key is having a datafilter, but in the datafilter you don't actually change the data. You just leave it alone and set Handled to False.
In that case, the dropdown sorts by data value, not the display value.
I believe so, it's version 1043. That looks like the only downloadable hotfix I have access to.
Do you have the latest Hot Fix?
I'm using 7.3, so not too old.
What version of the grid are you using? That sounds like a bug that was fixed a long time ago.