Column sort by decimal1

[rodmcleay]

Hi I have a numberic column in my grid set to the NumberType of Decimal1.

<GUI:BindColumn Caption="Variation No" CommandText="" CustomFormat="" DataField="VariationNo" AlternativeStyle-BackColor="#FFFFDD" Style-BackColor="#FFFFDD" ImageUrl="" Width="75px" NumberType="Decimal1" IsReadOnly="True"> </GUI:BindColumn>

When I click on the header for this column it orders the data, but it does so based on the data being a string instead of a number.

ie 1,11,12,13,2,3,4,5,6,7,8,9 instead of 1,2,3,4,5,6,7,8,9,10,11,12,13

How can I get this to be ordered properly as a numeric field.

Any advise or assistance would be greatly appreciated.

[Amjad_Sahi]

Hi,

Well, I tested your scenario and I don't find the problem related sorting numeric data. Which version of Aspose.Grid.Web you are using? did you try our latest version: http://www.aspose.com/community/files/53/visual-components/aspose.grid/entry126616.aspx

If you still find the issue, kindly do create a sample test project, zip it and post it here with all the source files. We will check it soon.

Thank you.