Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by DM on Dec 05, 2009 11:59
open dhtmlx forum
Numeric sorting not working

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 columns dynamically, our indexes are not fixed & also we can not calculate the total number of columns beforehand. so is there a way to specify the decimal separator & group separator in <TD> itself as properties like format, type etc.

Regards
Dhiraj
Answer posted by dhxSupport on Dec 07, 2009 01:45
Unfortunately FrenchNumerics.html file is not attached. Can you please re-send it. Also please provide example of grid initialization. Please send this information directly to the support@dhtmlx.com
Answer posted by DM on Dec 07, 2009 04:12
Kindly find requested FrenchNumerics.html for ur reference & let me know if you need anything else...
Attachments (1)
Answer posted by Stanislav (support) on Dec 07, 2009 09:02
It not possible to define localized version of formatting through format attribute, but still can be done from html as 


<table style="width:800px;" class="dhtmlXGrid" imgpath="dhtmlxGrid/codebase/imgs/" name="pressRoomGridBox" gridWidth="800px" id="pressRoomGridBox" onbeforeinit="pressRoomGridBox.setNumberFormat('0,000.00',0,',','.')">
<tr>
<td type="edn" sort="int">Affich&eacute; le</td><td sort="sortHyperLinks">Article</td>