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
using comma as decimal separator while editing
17/08/2009
07:00
Avatar
birt
Member
Members
Forum Posts: 20
Member Since:
20/11/2008
sp_UserOfflineSmall Offline

Hello,

I would like to use a comma (,) as decimal separator also in edit mode (I'm using celledit). Is that possible??
It is much easier to enter a number as 12,23 rather than 12.23 (with swedish keyboard and settings).

(I'm using grid.locale-sv.js file, which has comma as decimal separator, so I would prefer edit whitout unformating the values.)

I tried to go around this with putting a function that replaced a comma (,) with a dot (.) in the beforeSaveCell event. With this function it was ok to enter a value such as 12,23 which was converted to 12.23 "in the background". It seemed to work until I added 'formatter:number' to the colModel. After that the edited cell returns NaN so it doesn't like my "convert function". I'm not sure why since when looking in the database everything looks good (with correct values) and when reloading the grid, it accepts the edited value and shows it as supposed.

But even if I would solve this in any way, I don't know how to solve it when adding a row, because the add function hasn't any beforeSaveCell event....

Help would be very appreciated!

/T

17/08/2009
07:53
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

The purpose of this is that the calculations with , does not work - also the number is converted in a readable and calculatable format.

1. If your server return the numbers with comma I think that you should not use a formatter, but if you want thia

2. I think that this is a good solution : http://www.trirand.com/jqgridw....._formatter

Best Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
136 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