jQuery Grid Plugin - jqGrid - Topic: cell formatting on edit

tony on cell formatting on edit

Sun, 21 Jun 2009 07:00:19 +0300

Hello,

If you use the buil in jqGrid formatter:'currency' jqGrid will do the job for you if you edit the value. Since I suppose you value is formatted server side you can look here in order to do the things.

http://www.trirand.com/blog/?p.....ons/page-1

Regards

Tony

Drew on cell formatting on edit

Fri, 19 Jun 2009 10:17:36 +0300

Well, I got it working for me. Obviously a callback solution would be much more elegant, but here's what I did:

$('#FCGrid').jqGrid({
   ...
   onSelectRow: function(id) {
var _cellOne = $('#FCGrid').getCell(id, 'ColumnName');
      $('#FCGrid').editRow(id, false);
      document.getElementById(id + '_ColumnName').value = _cellOne.replace(/\\$|\\,/g, '');
   }
});

I had been trying with a jQuery selector rather than document.getElementById and it wasn't working. For some reason, doc.getEl does work though. Hope this is helpful for others =]

Marcel Karras on cell formatting on edit

Fri, 19 Jun 2009 05:30:52 +0300

Yes, I'm interested in a solution, too. 🙂

Drew on cell formatting on edit

Thu, 18 Jun 2009 16:41:59 +0300

Bump ^_^

Drew on cell formatting on edit

Wed, 17 Jun 2009 20:22:29 +0300

I have a cell displaying a currency value, such as "$102.75". When I begin editing the row, I'd like to change the text of the input to "102.75" -- without the dollar sign. What would be the best route to accomplish this?

Currently, I'm trying: on row select, I'll get the original value. Then call editRow. Then set the text. However, when I get the textbox and set its text, it doesn't appear to actually change.

I guess that could also serve as a feature request, it'd be nice to have a callback function for this - perhaps included in the editrules.