EnhancedGrid Globalization - Problems when sorting columns of numbers or amounts

[Roberto Mosqueda]

Testing Type: Globalization

Browsers Affected: IE 6,7 and 8, Firefox 3.0 and 3.5, Safari 4, Chrome

Problem Description: The sorting function is done in base on the unicode value of the numbers instead of the numeric value that represents the complete number.

Steps to Reproduce:

1.- Open the browser
2.- Have a column with some amounts on the enhanced grid table
3.- Go to /test_enhanced_grid.html
4.- Click on the single sort button on the column header

Actual Result : See image1.gif to see the sorted column.

Expected Result: The sort must be done in base on the value of the number not the unicode value of the characters.

[Adam Peller]

I'm going to say this is working as designed. It's sorting the cells alphabetically (reverse alphabetically here?) since there's no way to know that these are numbers or currencies. Also, as far as I know, nothing here is unique to the EnhancedGrid?.

This may not be documented well, but a proper way to do this is in the test case at dojox/grid/tests/test_edit_dijit.html using Dijits to do currency formatting based on plain number values, which are sorted correctly. You can just set up formatters without the dijits also.