We often have columns containing alphanumeric characters. The sorting on this value is is 'string' based, so i.e. the sorting is then as following:
- P1
- P10
- P2
- P3
Where as a user would expect some alphanumeric sorting:
- P1
- P2
- P3
- P10
We currently work-around on this by having an extra hidden sorting column filling the numbers (P0000001) and then apply string sorting on the hidden column. However, when the user clicks on the column, the alphanumeric sorting disappears.
Maybe a suggestion for this problem would be to assign a 'sorting column' to columns if necessary. This column must be a hidden column. Or just tag columns as ‘alpha numeric’. I.e. the column 'name' should be sorted based on the value of the column 'name_sort', which must be / or can be hidden.