jQuery Grid Plugin - jqGridForum

Topic RSS

How to edit a currency cell?

23/03/2010
05:32

jackysee

Member

Members

Forum Posts: 24

Member Since:
22/03/2009

Offline

I have a colModel

{
name:'cost',index:'cost', width:100, formatter:'currency', formatoptions:{decimalSeparator:'.', thousandsSeparator: ',', decimalPlaces: 2, prefix: '', defaultValue:''}, editable:true, edittype:'text', editoptions: {size:30, maxlength: 22}, editrules:{number:true}
}

It can shows '$1,400.20' at the table cell. But when I click edit using the modal form will also fill in '$1,400.20' in the input field. How can I control such that it will display '1400.20'?

25/03/2010
09:42

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

According to your code, this field should not contain "$" as prefix, since you set a prefix to be empty string.

Also the conversion should be done automatically if you use the build in formatters, so please look at your code again.

Best Regards

Tony

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.

25/03/2010
10:15

jackysee

Member

Members

Forum Posts: 24

Member Since:
22/03/2009

Offline

Do you mean that the formatter must be 'currency' for it to work properly? I tried to do something like:

$.extend(true, $.fn.fmatter, {
amount: function(cellvalue, options, rowdata){
var op = $.extend(true, {}, options, {
currency: {
decimalSeparator:'.', decimalPlaces:2, suffix:'', prefix:', thousandsSeparator:',', defaultValue:' '
}
});
options.colModel.align = 'right';
return $.fn.fmatter.currency(cellvalue, op, rowdata);
}
});

so that I can simply use formatter:'amount' in colModel. I need to also specify an unformatter for cell edit?

31/03/2010
17:42

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Just define the unformat function and everthing will be OK.

http://www.trirand.com/jqgridw.....r_function

Regards

Tony

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.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
32 Guest(s)

Currently Browsing this Page:
1 Guest(s)