jQuery Grid Plugin - jqGrid - Topic: Number Formatting http://www.trirand.com/blog/?page_id=393/help/number-formatting Simple:Press Version 5.7.5.3 sanchitos on Number Formatting http://www.trirand.com/blog/?page_id=393/help/number-formatting#p12205 Help http://www.trirand.com/blog/?page_id=393/help/number-formatting#p12205 Well i think that the problem is that SQL Server saves decimal values with a comma, and the parse float uses a dot as decimal separator.

Sql database: 25,30

Parse float (25,30) -> 25

Parse float (25.30) -> 25.30

the NaN i'm getting is not from the jqgrid, is from the parsefloat.

Thanks

]]> Thu, 19 Nov 2009 16:00:21 +0200 sanchitos on Number Formatting http://www.trirand.com/blog/?page_id=393/help/number-formatting#p12203 Help http://www.trirand.com/blog/?page_id=393/help/number-formatting#p12203 Using 3.5 version.

Sql Server 2008.

Value recovered is of type decimal.

I'm experiencing a NaN column value when i try to format to type number.

When my number > 1000 without format the value looks like this in the Grid: 50000,00. I would like that is like 50.000,00. So i tried to use the number formatting.

File locale-sp.js has this statement:

formatter : {
...
        number : {decimalSeparator:",", thousandsSeparator: ".", decimalPlaces: 2, defaultValue: '0,00'},

...

}

So in my grid i wrote this:

colModel: [
..
                      { name: 'valor', index: 'valor', width: 50, align: 'right', formatter: 'number'},

..

]

BUT, the value is NaN, any help?

Thank you

]]> Thu, 19 Nov 2009 15:34:24 +0200