Problems Sorting European Currency

The Row is formatted as number. So the sorting works fine when the decimal point is "." and the thousands seperator is ",".

But the European currency has this syntax 14.254,25. <= don't work
If this value has got this syntax 14,254.25 or 14254,25 or 14254.25 it works.

Is there any possibillity to get this working ??

One way to make it work is to create your own formatting class, which will be able to parse the numbers in this format (i.e. textToValue method)

Another way is to send the data as js numbers and format them at the client side -

http://www.activewidgets.com/aw.ui.grid/cell-format.html

The values are already formated in the right way,....

But the sorting doesn't work.

Don't know how and where to set up the sorting in thr right way

1. sounds like the best option is just use js numbers like alex said.

2. sorting is automatic unless you override it, you can give the columns a format like alex showed, but there are only a few standard ones.

*i believe the reason it is not working is that your code reads the numbers as strings. which brings us back to #1