jQuery Grid Plugin - jqGrid - Topic: How to edit a currency cell? http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell Simple:Press Version 5.7.5.3 tony on How to edit a currency cell? http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p16087 Help http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p16087 Hello,

Just define the unformat function and everthing will be OK.

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

Regards

Tony

]]> Wed, 31 Mar 2010 17:42:00 +0300 jackysee on How to edit a currency cell? http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p15946 Help http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p15946 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?

]]> Thu, 25 Mar 2010 10:15:59 +0200 tony on How to edit a currency cell? http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p15940 Help http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p15940 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

]]> Thu, 25 Mar 2010 09:42:45 +0200 jackysee on How to edit a currency cell? http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p15902 Help http://www.trirand.com/blog/?page_id=393/help/how-to-edit-a-currency-cell#p15902 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'?

]]> Tue, 23 Mar 2010 05:32:23 +0200