editing price type cell

Discontinued products Uncategorized discussions
#1

I define a column type as price. when I edit the cells in that column, i noticed that the cell value will not be changed if any of the alphabetic characters are typed in. Is there any way I can alert the users when they type in any alphabetic characters ?



Thanks

#2

You can use onEditCell event to show any custom message after edit operation.
Instead of showing message you can just remove any not-numerical characters

mygrid.attachEvent(“onEditCell”,function(stage,id,ind,value){
    if (stage==2 && index==INDEX){
       return value.toString().replace(/[^0-9,]+/g,"")
    }
    return true;
});


where INDEX - index of column in question