jQuery Grid Plugin - jqGrid - Topic: Number formats in form edit, decimal point or comma

wizrd66 on Number formats in form edit, decimal point or comma

Wed, 25 Jul 2012 17:12:15 +0300

To fix this issue, I changed from using the built in edtrul.number to use edtrul.custom

sim to this

col.editrules.custom = true;
 col.editrules.custom_func = (function (val, nm) { if (isNaN(val.replace(decimalsep, '.'))) { return [false, nm + ": " + $.jgrid.edit.msg.number] } return [true, ""] });

wizrd66 on Number formats in form edit, decimal point or comma

Tue, 24 Jul 2012 20:58:30 +0300

I am having the exact same issue.

I am doing an inline edit and the language settings are set to spanish. So the number formatting is a comma for decimalseparator and period for thousands separator. We have written unformat and format functions all is good there.

When a user edits a row, and they lets put in 26000,50 and they hit enter. The Grid throws an error. where 26000.50 is ok. Our users want to be able to put in a comma. I have seen posting on this and no real suitable fix .. It seems to me that this would be a common request and that being able to enter a number in the lanquage type you have selected would be expected.

I tracked the issue down to this section of code, in the jqgrid code in the checkvalues function.

if(edtrul.number === true) {
if( !(rqfield === false && this.isEmpty(val)) ) {
if(isNaN(val)) { return [false,nm+": "+$.jgrid.edit.msg.number,""]; }
}

the isNaN(val) check of course fails..

I was wondering wouldn't

if(isNaN(val.replace(opts.decimalSeparator,".")))

Be a better check? or is there someway to run unformat on this before is runs the saverow function?

I would think you would re-run unformat after the user edits the data for a row.

if(edtrul) {
			if(!nm) { nm = g.p.colNames[valref]; }
			if(edtrul.required === true) {
				if( this.isEmpty(val) )  { return [false,nm+": "+$.jgrid.edit.msg.required,""]; }
			}
			// force required
			var rqfield = edtrul.required === false ? false : true;
			if(edtrul.number === true) {
				if( !(rqfield === false && this.isEmpty(val)) ) {
					if(isNaN(val)) { return [false,nm+": "+$.jgrid.edit.msg.number,""]; }
				}

tony on Number formats in form edit, decimal point or comma

Sun, 20 Jun 2010 11:15:49 +0300

Hello,

You can avoid this, suppessing the checking und use your own formatter and unformatter to return the original value.

The reason that you have a error when you enter a number with decimal separator "," is that the javascript isNaN function work only with numbers that have decimal separator ".".

Also you can define your own validator for your number.

Regards

Tony

caroig on Number formats in form edit, decimal point or comma

Mon, 14 Jun 2010 22:00:34 +0300

Hi,

I'm using v3.6.5 and it works great. But I have a problem with my number formats. My system is in spanish and I'm loading the spanish localization and using formatter to get the grid data displaying correctly - so far so good.

I'm using formatter in my colModel and all my floats display fine with a comma decimal separator (e.g. 12,53). When I come to edit or add new rows, the data displayed in the popup form shows floats with a dot seperator (e.g. 12.53).

If I enter numbers in the edit form with the dot decimal separator e.g. 12.53 - they are displayed correctly in the grid e.g. 12,53.

If I enter data in the form with the comma separator, I get a validation error (from formatter I guess) that the field is not numeric.

What do I need to do to ensure that my form displays and validates numbers with a comma decimal seperator.

P.S. My data is not bound I use a dummy fille for the editurl and set reloadAfterSubmit:false on edit