Hello,how can I sort a column (click in the header) with the values:
3,52E011,41E00>3,07E012,72E-01
I have two problems:1. less/greater-sign2. the character E (scientific notation)
sorted (the first signs to letter E will be sorted):>3,07E011,41E002,72E-013,52E01
How can I solve this problem?
Alexander
Hi Mike,
it is correct. I storing these values as strings. I will use the SortComparer property.
Hi Alexander,
What data type are you using here? If it's a numeric type and you are using Format to display it in scientific notation, then it should sort correctly.
It looks to me like you are storing these values as strings.
If you are using strings, then you will need to use the SortComparer property of the column to provide a custom IComparer that sorts the strings how you want them.