Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Number Formatting
19/11/2009
15:34
Avatar
sanchitos
Member
Members
Forum Posts: 14
Member Since:
05/10/2009
sp_UserOfflineSmall Offline

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

19/11/2009
16:00
Avatar
sanchitos
Member
Members
Forum Posts: 14
Member Since:
05/10/2009
sp_UserOfflineSmall Offline

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

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
58 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information