Solution found ! example and code on
http://flextricks.wordpress.com/2007/02/03/sorting-numeric-values-in-a-flex-datagrid/ --- In flexcoders@yahoogroups.com, "amigo_fd" <[EMAIL PROTECTED]> wrote: > > any ideas on how to do this with sortCompareFunction ? > > --- In flexcoders@yahoogroups.com, "amigo_fd" <frank@> wrote: > > > > Hello, it looks like all data in a datagrid is treated as text. So if > > you sort a column with only numeric fields it is sorted on the value > > of the textual contect, instead of the numeric value, like this: > > > > 1095 > > 111 > > 1276 > > 144 > > ... > > > > I already converted my webservice-result to numbers at loading, but > > sorting keeps using text-value ... How to change this ? > > > > dgInvoiceListGrouped.dataProvider = new XMLListCollection(x.children()); > > var GroupedArray:Array = []; > > > > for (var j:Number = 0; j < dgInvoiceList.dataProvider.length; j++) { > > GroupedArray[j] = {Name: > > dgInvoiceListGrouped.dataProvider.getItemAt(j).Name.toString(), > > Country: > > dgInvoiceListGrouped.dataProvider.getItemAt(j).Country.toString(), > > GroupedTotalExcl: > > > Number(dgInvoiceListGrouped.dataProvider.getItemAt(j).GroupedTotalExcl.toString()), > > GroupedTotalIncl: > > > Number(dgInvoiceListGrouped.dataProvider.getItemAt(j).GroupedTotalIncl.toString())}; > > } > > > > dgInvoiceListGrouped.dataProvider = []; > > dgInvoiceListGrouped.dataProvider = GroupedArray; > > >