sorting on cell value

[tom]

Hi,

I have a grid where column A takes the size of an array and, depending on if the status in column B is right, outputs the array's length. If the status is not right, the output is a -. When I sort, the underlying value from the field is sorted, whereas I want the cell's value to be sorted. The column may look like this:

5

3

-

6

-

4

and I would want it to sort to 

6

5

4

3

-

-

 

Currently it sorts to because the underlying value of the - is 6 and 4

6

-

5

4

-

3

 

Is there any way to sort by the cell and not the field? 

[Stefan]

Hello, Tom,

There are some options in this case as the sorting is done outside of the Grid:

1) Process the data and create a new field that will hold values that will be the same as the display values. Then when sorting, instead of sorting by the column A value, sort by that field. The issue with that approach is that the visual indication will be missing.

2) The sorting logic can be modified once this feature is available:

https://github.com/telerik/kendo-react/issues/819

3) Use custom sorting on the client or on the server that will sort the data based on the application requirement.

Regards,
Stefan
Progress Telerik