jQuery Grid Plugin - jqGrid - Topic: unformat and sorting w/v3.7.2 http://www.trirand.com/blog/?page_id=393/help/unformat-and-sorting-wv3-7-2 Simple:Press Version 5.7.5.3 jakemonO on unformat and sorting w/v3.7.2 http://www.trirand.com/blog/?page_id=393/help/unformat-and-sorting-wv3-7-2#p23618 Help http://www.trirand.com/blog/?page_id=393/help/unformat-and-sorting-wv3-7-2#p23618 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!

]]> Wed, 15 Jun 2011 17:53:44 +0300