Sorting issue with data grid

Hi All,

The following two test case was raised by Bhasker. If any of you have a solution to this problem. Please post your solution in this forum.

Case 1:
(1) Grid has 5 rows
(2) Sort on any column
(3) Reload Grid (Now xml table has 3 actual rows) Grid displays 3 rows + 2 blank rows
(4) The 2 blank rows are an issue.

Case 2:
(1) Grid has 3 rows
(2) Sort on any column
(3) Reload Grid (Now xml table has 4 actual rows) Grid displays 3 rows; 4 th row is never displayed
(4) The 2 blank rows are an issue.

If any of you have a solution to this problem then please help.

function getValue(i,j){
    
        var text = "" + myData[i][j];
        if (text.match(/^\\s*\$/)) {return "!"}
        var value = Number(text.replace(/[ ,%\\\$]/gi, "").replace(/\\((.*)\\)/, "-\$1"));
        return isNaN(value) ? text.toLowerCase() + " " : value;
        
    }

grid.setDataProperty("value", getValue);

fixed it for me. note the return "!" which was slightly different from other postings but I needed it to get the sort working.