jQuery Grid Plugin - jqGrid - Topic: False Sorting of Integer with thousandsSeparator http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator Simple:Press Version 5.7.5.3 tony on False Sorting of Integer with thousandsSeparator http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9446 Help http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9446 Hello,

Thanks. Already fixed in in 3.5.3 Release.

Regards

Tony

]]> Tue, 08 Sep 2009 08:32:59 +0300 Juergen on False Sorting of Integer with thousandsSeparator http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9375 Help http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9375

markw65 said:

Looks like something along the lines of:

var sep = op.thousandsSeparator.replace(/([\\.\\*\\(\\)\\{\\}\\+\\?\\\\])/g,”\\\\$1″);

stripTag = new RegExp(sep, “g”);

should do the trick.

Yes! It does the trick.

Thanks a million!Laugh

Juergen

]]> Fri, 04 Sep 2009 14:07:43 +0300 markw65 on False Sorting of Integer with thousandsSeparator http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9361 Help http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9361 The problem is in $.unformat:

stripTag = eval("/"+op.thousandsSeparator+"/g");
ret = $(cellval).text().replace(stripTag,'');

If op.thousandsSeparator is ".", that replaces the entire text with '' (the pattern becomes /./g which matches everything).

Looks like something along the lines of:

var sep = op.thousandsSeparator.replace(/([\\.\\*\\(\\)\\{\\}\\+\\?\\\\])/g,"\\\\$1");

stripTag = new RegExp(sep, "g");

should do the trick. I think that covers all the special chars. An alternative would be:

sep = op.thousandsSeparator.replace(/([^\\w\\s])/g,"\\\\$1");

That should guarantee to hit all the chars that need quoting - but also hits a few that dont.

]]> Fri, 04 Sep 2009 10:59:49 +0300 Juergen on False Sorting of Integer with thousandsSeparator http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9356 Help http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9356 Hello Tony,

the sorttype in colModel is set to "int":

jQuery(document).ready(function(){   

tableToGrid('#irgendwas',
{ height:370,
colNames:['Artikelnummer','Bezeichnung1', 'Bezeichnung2', 'Bezeichnung3','Bestand','Abfragedatum'],

colModel:[
{name:'Artikelnummer',index:'1', width:"115", sorttype:"int",align:'right'},
{name:'Bezeichnung1',index:'2'},
{name:'Bezeichnung2',index:'3'},
{name:'Bezeichnung3',index:'4'},
{name:'Bestand',index:'5', sorttype:'int', width:"90", formatter:'integer',align:'right'},
{name:'Abfragedatum',index:'6', sorttype:"date"}],
autowidth:true});

Regards

Juergen

]]> Fri, 04 Sep 2009 09:52:29 +0300 tony on False Sorting of Integer with thousandsSeparator http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9328 Help http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9328 Hello,

Do you have set in colModel the property sorttype of that column, this is needed when we use local data

http://www.trirand.com/jqgridw.....array_data

Regards

Tony

]]> Fri, 04 Sep 2009 05:11:52 +0300 Juergen on False Sorting of Integer with thousandsSeparator http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9255 Help http://www.trirand.com/blog/?page_id=393/help/false-sorting-of-integer-with-thousandsseparator#p9255 Hello!

I am using grid.locale-de.js - if i set a dot as thousandsSeparator:

formatter:{integer:{thousandsSeparator:".",defaultValue:"0"}

The Numbers are sorted in false order e.g. 0,1021,213 indstead of 0,213,1021

If i use an other thousandsSeparator like space " " the numbers are sorted correct.

Can anybody help me

Juergen

]]> Thu, 03 Sep 2009 06:42:56 +0300