jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

unformat and sorting w/v3.7.2

Tags: formatter unformat Sorting

15/06/2011
17:53

jakemonO

Member

Members

Forum Posts: 16

Member Since:
20/08/2010

Offline

I've been using jqGrid 3.7.2 for over a year & its working fine. I now have a numeric column in which I don;t want zero values to show up and I want sortable. I created a custom formatter to strip out zeroes and an unformatter to put them back in for sorting algorithm purposes. I've tried using not a "" as a zero replacement and " " but I can't seem to get the unformatter to work and the sort breaks. Any help/suggestions are appreciated. I'd prefer NOT to upgrade the grid version at this time, but if that's a definitive answer I'd consider it. Informal testing suggests the problem exists w/v3.8.2 and 4.1.0.

Formatter & unformatter:

function noZeroNumberFormatter(el, cellvalue, rowObject) {
if (window.console) console.log("noZeroNumberFormatter - before: " + el + ", after: " + ((el == "") ? " " : el));
return (el == "0") ? " ": el;
}

function noZeroNumberUnformatter(el, cellvalue, rowObject) {
if (window.console) console.log("noZeroNumberUnformatter - before: " + el + ", after: " + ((el == " ") ? 0 : parseInt(el,10)));
return (el == " ") ? 0 : parseInt(el,10);
}

(as explained, I've tried non breakable space and "" literal)

col def:

{name: 'dQtry', label:'Damage Qty', sortable: true, title: false, align: 'center', formatter: noZeroNumberFormatter, unformat: noZeroNumberUnformatter, sortttype: 'number', width: 40},

Thanks in advance!

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
26 Guest(s)

Currently Browsing this Page:
1 Guest(s)