Sorting numbers and dates in a KGrid
===

I have a KGrid in a Lazarus project that contains different columns with numeric, text and date data.

Sorting by the column with text data is OK but sorting by the columns containing numeric or date data does not work at all.

For instance

10,2,3,1,4,21,30 is sorted as 1,10,2,21,3,30,4 in that order.

Does anyone use KGrid and is there a way to change the grid's OnCompareCells event so that the sorting is done correctly?

Thanks.   