Start Building Professional
Web Apps Today

Number sorting not working for french formats

Hi..

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

<td type="edn" format="0,000.00" sort="int">Affiché le</td> (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 <TD> itself as properties like format, type etc.

Regards
Dhiraj

 

Kindly find attached zip for more details..