Forum


07:00

20/11/2008

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
07:53

Moderators
30/10/2007

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.
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.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66