DevExpress Datagrid sorting

Question

In a DexEpress ASPxGridView I have a column that contains voltage. The original values look like 200, 1000, 120 but I am applying a scaling that transforms the values into 200 V, 1 kV and 120 V.

How do I sort the column based on the original values and not the string values?

(In a .Net datagrid I had 2 columns: one with the original data (hidden) and one with the transformed data and I used the original data column to sort the rows. Is there something similar here?)

Answer 1

Hi,

Set the column's Settings.SortMode to the Value property. This should force the grid sort value in this column the way you need it.