When I use sort with the sort buttons in the header of the DataGrid and the column content is numbers they are not sorted as numbers but as strings. For example 994,50 808,50 444,00 92,00 5,00 5.244,50 4.765,50 1.771,00 0,00
The column type is specified as number for the column : "ItemSumPrice"=>array(
"type"=>"number",
"decimals"=>2,
"dec_point"=>",",
"thousand_sep"=>".",
"cssStyle"=>"text-align:right;width:100px;white-space:nowrap",
"label"=>"Τζίρος()",
"footer"=>"sum",
),
If however I remove the "dec_point"=>",", "thousand_sep"=>"." specifications then they sort corectly. Thus it seems that it changes the type to string when displaying the data but does not take this into account when sorting.