Hi,
I have an Excel looking like this:
Column1, Column2, Column3
XX, XX, -1040
XX, XX, -104
XX, XX, -1072
XX, XX, -1087
XX, XX, -111
I want to read this and sort the DataTable based on valuesd in “Column3”. This is the result using when using DataView.Sort(ascending):
-104
-1040
-1072
-1087
-111
This is of course not the result im looking for. Does anyone have any idea how i can do this sorting?