In html, Filtering columns first by number value, then by alphabet

[Clint]

Hello, the project I am working on is creating a kendo sheet via a string that is passed to the View, e.g.:

"{\"sheets\": [{\"frozenRows\": 1, \"frozenColumns\": 1, \"name\": \"xxxx\", \"filter\":{\"ref\":\"A1:Z__\", \"columns\":[]}, ......."

I need to modify this string to change the column sorting to filter first by numerical value, then by alphabetical order.  The bug being reported with the current filter setup is that if you sort a column that has e.g. between 10 and 20 rows in it, with values of consecutive integers like 1, 2, 3, ..., the sorted order will be:

1

10

2

3

...

 

I need to get the column to sort the numbers in correct ascending order first, and then by alphabetical order following any integer values at the start.  Can I ask for help on how to do this?  Thank you!

[Aleksandar]

Hi Clint,

I am not sure I understand the issue. In this dojo, sorting on Quantity sorts the items as expected. Would it be possible to modify the example so the issue reported can be observed and send it back to me for further review?

Regards,
Aleksandar
Progress Telerik

[Clint]

Hi Aleksander, I apologize, the problem was on our end, we were inserting the numeric data into the kendo spreadsheet as a string, rather than in its original numeric data type.  So sorry for the trouble, thank you for your help!