You need a sortCompareFunction:
In your script area add...
import mx.utils.ObjectUtil;
Then add the following function...
private function myCompareFunc(itemA:Object, itemB:Object):int
{
return ObjectUtil.numericCompare(itemA.Quoted_Total,
itemB.Quoted_Total);
}
Now change your DataGridColumn component to...
<mx:DataGridColumn headerText="Formatted Total (Flex will now sort)"
sortCompareFunction="myCompareFunc">
That should do it.
HTH.
--- In [email protected], "Kevin Ford" <[EMAIL PROTECTED]> wrote:
>
> I need someone to help verify a problem I'm running into and perhaps
> recommend a solution. What I'm trying to do should be very simple: I
want to
> allow users to sort a datagrid column containing data formatted using
a
> CurrencyFormatter. The problem I'm finding is that sorting (by
clicking the
> column header) works fine on raw numbers, but trying to do the same on
> formatted numbers doesn't do anything. I'm using Flex Builder 3, but
have
> tried this using both the Flex 2 and Flex 3 compilers on two different
> systems. Initially I was trying this using an AdvancedDataGrid, but
found
> the same problem using just a basic DataGrid.
>
> Attached is a simple mxml file that fully demonstrates my problem. I
also
> have a bug logged with
Adobe(http://bugs.adobe.com/jira/browse/FLEXDMV-1769)
> that I'd love to cancel. Am I missing something? Am I just going to
have to
> define my own sort function?
>
> Thanks!
> Kevin
>
