Rows B, D and E do not sort correctly, basically because I am assuming they have numbers with unmatching or too many places. I can not find any help online with this. The columns with percentages work fine unless they go over 99%. ??
import fl.controls.DataGrid;
import fl.controls.dataGridClasses.DataGridColumn;
import fl.data.DataProvider;
var dp:DataProvider = new DataProvider();
dp.addItem({State:"Alabama",Liability:"$41,634,554","% Funded":"74%",ARC:"$1,214,983","% Contributed":"100%"})
dp.addItem({State:"Alaska",Liability:"$15,347,768","% Funded":"61%",ARC:"$268,127","% Contributed":"110%"})
dp.addItem({State:"Arizona",Liability:"$44,078,394","% Funded":"78%",ARC:"$1,141,602","% Contributed":"101%"})
dp.addItem({State:"Arkansas",Liability:"$22,698,906","% Funded":"78%",ARC:"$534,954","% Contributed":"103%"})
dp.addItem({State:"California",Liability:"$490,585,000","% Funded":"81%",ARC:"$12,422,673","% Contributed":"82%"})
dp.addItem({State:"Colorado",Liability:"$54,536,549","% Funded":"69%",ARC:"$1,310,315","% Contributed":"66%"})
dp.addItem({State:"Connecticut",Liability:"$41,311,400","% Funded":"62%",ARC:"$1,307,200","% Contributed":"96%"})
var colA:DataGridColumn = new DataGridColumn("State");
var colB:DataGridColumn = new DataGridColumn("Liability");
var colC:DataGridColumn = new DataGridColumn("% Funded");
var colD:DataGridColumn = new DataGridColumn("ARC");
var colE:DataGridColumn = new DataGridColumn("% Contributed");
/*colB.sortOptions = Array.NUMERIC;
colC.sortOptions = Array.NUMERIC;
colD.sortOptions = Array.NUMERIC;
colE.sortOptions = Array.NUMERIC;*/
var myDataGrid:DataGrid = new DataGrid();
myDataGrid.sortableColumns = true;
myDataGrid.addColumn(colA);
myDataGrid.addColumn(colB);
myDataGrid.addColumn(colC);
myDataGrid.addColumn(colD);
myDataGrid.addColumn(colE);
myDataGrid.dataProvider = dp;
myDataGrid.width = 600;
myDataGrid.rowCount = myDataGrid.length;
myDataGrid.move(10, 10);
addChild(myDataGrid);
