Number sorting not working for french formats

Hi…



To specify the sorting for numeric fields, we are using the following line of code:



Affiché le (Plz find attached sample html, EnglishNumerics.html for more details)



This is working fine for english locale when I specify the format (0,000.00)…But for french locale when I am specifing the format

(0 000,00), it’s not working (space as group separator and “,” as decimal separator). (FrenchNumerics.html attached)



I know there is an altenative, grid.setNumberFormat(mask, cInd, p_sep, d_sep) to do this, but as we need to generate these rows dynamically, our indexes are not fixed & also we can not calculate the total number of rows beforehand. so is there a way to specify the decimal separator & group separator in itself as properties like format, type etc.



Regards

Dhiraj






 



Kindly find attached zip for more details…


Date Issue.zip (392 KB)