jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

Loosing Locale Information in Formatters with inline editing

Tags: locale currency formatter inline edit

08/11/2010
14:29

chronohh

Member

Members

Forum Posts: 3

Member Since:
26/10/2010

Offline

Hi there

jqGrid 3.8.1 is set up with a column formatted as "currency", loaded with german locale.

Server sends the following data: "3097.23".

jqGrid displays this value as "3.097,23 €". This is right!

But after clicking on the cell for starting inline editing, this cell get transformed back to "3097.23".

Maybe there comes another bug from a previous version alive: http://www.trirand.com/blog/?p.....matter-bug

kind regards

chronohh

09/11/2010
17:29

chronohh

Member

Members

Forum Posts: 3

Member Since:
26/10/2010

Offline

I just found the problem by myself:

in file "grid.inlineedit.js" at row number 27 there is the following code:

try {
tmp = $.unformat(this,{rowId:rowid, colModel:cm[i]},i);
} catch (_) {
tmp = $(this).html();
}

Just throwing this stuff away and writing

tmp = $(this).html();

is the solution for us.

Do you see any problems with that?

I suggest, that unformatting the values should happen for sending data to the server, not in display situation.

Kind Regards,

chronohh

09/11/2010
18:03

chronohh

Member

Members

Forum Posts: 3

Member Since:
26/10/2010

Offline

Oh, there are side effects with the solution i mentioned above when you start inline editing but make no changes. When you press escape or leave the cell while clicking on another one, you will receive an "NaN"-Value in the column.

This is because of code in "jquery.fmatter.js", Line 67:

Change

nData *= 1;

return nData;

Regards, chronohh

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
22 Guest(s)

Currently Browsing this Page:
1 Guest(s)