Numeric sorting not working

Discontinued products Uncategorized discussions
#1

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 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 itself as properties like format, type etc.



Regards

Dhiraj

#2

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

#3

Kindly find requested FrenchNumerics.html for ur reference & let me know if you need anything else…
Number Format.zip (394 KB)

#4

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,’,’,’.’)”>


Affiché le Article