[RESOLVED] DataGrid not sorting columns, Help

[ADVaughn]

I am using DataGrid in a project and it is not sorting the columns correctly. 0-99 seem to sort properly but if a number has 3 or more digits it doens't seem to work. Here is my AS code and array:

//* DATA GRID *//

import fl.controls.DataGrid;
import fl.controls.ScrollPolicy;

var myDataGrid:DataGrid = new DataGrid(); 
myDataGrid.addColumn("State"); 
myDataGrid.addColumn("Liability"); 
myDataGrid.addColumn("% Funded");
myDataGrid.addColumn("ARC"); 
myDataGrid.addColumn("% Contributed");



myDataGrid.addItem({State:"Alabama","Liability":"$41,634,554","% Funded":"074%","ARC":"$1,214,983","% Contributed":"100%"})
myDataGrid.addItem({State:"Alaska","Liability":"$15,347,768","% Funded":"061%","ARC":"$268,127","% Contributed":"110%"})
myDataGrid.addItem({State:"Arizona","Liability":"$44,078,394","% Funded":"078%","ARC":"$1,141,602","% Contributed":"101%"})
myDataGrid.addItem({State:"Arkansas","Liability":"$22,698,906","% Funded":"078%","ARC":"$534,954","% Contributed":"103%"})
myDataGrid.addItem({State:"California","Liability":"$490,585,000","% Funded":"081%","ARC":"$12,422,673","% Contributed":"82%"})
myDataGrid.addItem({State:"Colorado","Liability":"$54,536,549","% Funded":"069%","ARC":"$1,310,315","% Contributed":"66%"})
myDataGrid.addItem({State:"Connecticut","Liability":"$41,311,400","% Funded":"062%","ARC":"$1,307,200","% Contributed":"96%"})
myDataGrid.addItem({State:"Delaware","Liability":"$7,615,166","% Funded":"094%","ARC":"$148,940","% Contributed":"97%"})
myDataGrid.addItem({State:"Florida","Liability":"$141,485,280","% Funded":"084%","ARC":"$2,928,569","% Contributed":"108%"})
myDataGrid.addItem({State:"Georgia","Liability":"$79,898,410","% Funded":"087%","ARC":"$1,316,048","% Contributed":"100%"})
myDataGrid.addItem({State:"Hawaii","Liability":"$16,549,069","% Funded":"09%","ARC":"$488,770","% Contributed":"104%"})
myDataGrid.addItem({State:"Idaho","Liability":"$12,057,500","% Funded":"074%","ARC":"$235,626","% Contributed":"132%"})
myDataGrid.addItem({State:"Illinois","Liability":"$126,435,510","% Funded":"051%","ARC":"$4,076,467","% Contributed":"71%"})
myDataGrid.addItem({State:"Indiana","Liability":"$36,924,845","% Funded":"067%","ARC":"$1,293,765","% Contributed":"103%"})
myDataGrid.addItem({State:"Iowa","Liability":"$26,602,516","% Funded":"081%","ARC":"$495,196","% Contributed":"87%"})
myDataGrid.addItem({State:"Kansas","Liability":"$21,138,206","% Funded":"064%","ARC":"$660,833","% Contributed":"68%"})
myDataGrid.addItem({State:"Kentucky","Liability":"$35,686,737","% Funded":"058%","ARC":"$964,979","% Contributed":"58%"})
myDataGrid.addItem({State:"Louisiana","Liability":"$39,657,924","% Funded":"060%","ARC":"$1,375,288","% Contributed":"97%"})
myDataGrid.addItem({State:"Maine","Liability":"$14,410,000","% Funded":"073%","ARC":"$331,700","% Contributed":"100%"})
myDataGrid.addItem({State:"Maryland","Liability":"$53,054,565","% Funded":"065%","ARC":"$1,338,342","% Contributed":"84%"})
myDataGrid.addItem({State:"Massachusetts","Liability":"$61,140,335","% Funded":"068%","ARC":"$1,968,259","% Contributed":"66%"})
myDataGrid.addItem({State:"Michigan","Liability":"$72,911,900","% Funded":"079%","ARC":"$1,381,577","% Contributed":"100%"})
myDataGrid.addItem({State:"Minnesota","Liability":"$60,835,351","% Funded":"077%","ARC":"$1,128,407","% Contributed":"78%"})
myDataGrid.addItem({State:"Mississippi","Liability":"$31,386,747","% Funded":"067%","ARC":"$741,520","% Contributed":"100%"})
myDataGrid.addItem({State:"Missouri","Liability":"$55,314,996","% Funded":"079%","ARC":"$1,225,512","% Contributed":"90%"})
myDataGrid.addItem({State:"Montana","Liability":"$10,271,027","% Funded":"074%","ARC":"$196,002","% Contributed":"92%"})
myDataGrid.addItem({State:"Nebraska","Liability":"$9,427,370","% Funded":"088%","ARC":"$180,411","% Contributed":"100%"})
myDataGrid.addItem({State:"Nevada","Liability":"$33,148,347","% Funded":"072%","ARC":"$1,344,489","% Contributed":"90%"})
myDataGrid.addItem({State:"New Hampshire","Liability":"$8,475,062","% Funded":"058%","ARC":"$262,984","% Contributed":"75%"})
myDataGrid.addItem({State:"New Jersey","Liability":"$134,928,225","% Funded":"066%","ARC":"$4,053,524","% Contributed":"36%"})
myDataGrid.addItem({State:"New Mexico","Liability":"$29,003,362","% Funded":"076%","ARC":"$683,886","% Contributed":"93%"})
myDataGrid.addItem({State:"New York","Liability":"$146,733,000","% Funded":"101%","ARC":"$2,456,223","% Contributed":"100%"})
myDataGrid.addItem({State:"North Carolina","Liability":"$76,976,542","% Funded":"097%","ARC":"$762,442","% Contributed":"100%"})
myDataGrid.addItem({State:"North Dakota","Liability":"$4,475,800","% Funded":"081%","ARC":"$83,339","% Contributed":"80%"})
myDataGrid.addItem({State:"Ohio","Liability":"$171,194,371","% Funded":"066%","ARC":"$2,565,450","% Contributed":"94%"})
myDataGrid.addItem({State:"Oklahoma","Liability":"$34,815,244","% Funded":"057%","ARC":"$1,346,040","% Contributed":"77%"})
myDataGrid.addItem({State:"Oregon","Liability":"$56,810,600","% Funded":"086%","ARC":"$630,800","% Contributed":"100%"})
myDataGrid.addItem({State:"Pennsylvania","Liability":"$111,317,700","% Funded":"081%","ARC":"$2,405,156","% Contributed":"31%"})
myDataGrid.addItem({State:"Rhode Island","Liability":"$11,500,425","% Funded":"059%","ARC":"$320,173","% Contributed":"100%"})
myDataGrid.addItem({State:"South Carolina","Liability":"$42,050,701","% Funded":"069%","ARC":"$966,538","% Contributed":"100%"})
myDataGrid.addItem({State:"South Dakota","Liability":"$7,494,895","% Funded":"092%","ARC":"$95,280","% Contributed":"100%"})
myDataGrid.addItem({State:"Tennessee","Liability":"$35,198,741","% Funded":"090%","ARC":"$836,911","% Contributed":"100%"})
myDataGrid.addItem({State:"Texas","Liability":"$155,679,204","% Funded":"084%","ARC":"$2,611,397","% Contributed":"99%"})
myDataGrid.addItem({State:"Utah","Liability":"$24,299,183","% Funded":"086%","ARC":"$665,235","% Contributed":"100%"})
myDataGrid.addItem({State:"Vermont","Liability":"$4,012,955","% Funded":"073%","ARC":"$68,615","% Contributed":"93%"})
myDataGrid.addItem({State:"Virginia","Liability":"$69,135,000","% Funded":"080%","ARC":"$1,608,466","% Contributed":"82%"})
myDataGrid.addItem({State:"Washington","Liability":"$57,754,700","% Funded":"099%","ARC":"$1,829,700","% Contributed":"73%"})
myDataGrid.addItem({State:"West Virginia","Liability":"$14,266,419","% Funded":"06%","ARC":"$541,482","% Contributed":"96%"})
myDataGrid.addItem({State:"Wisconsin","Liability":"$79,104,600","% Funded":"100%","ARC":"$699,300","% Contributed":"100%"})
myDataGrid.addItem({State:"Wyoming","Liability":"$7,401,614","% Funded":"089%","ARC":"$169,712","% Contributed":"63%"})


myDataGrid.sortableColumns = true;
myDataGrid.width = 500;
myDataGrid.height = 164;
myDataGrid.verticalScrollPolicy = ScrollPolicy.ON; 
myDataGrid.move(0, 0);

[ADVaughn]

thing I do not undestand is it seems to sort "% Funded" column fine.



Ahh I see the reason that column is sorting correctly is I have made all values the same length by adding a "0" in fron of two digit numbers. Don't really want that to show in the table though