Cell validation possible?

Suite and Optimus Suite 5
#1

I have around 5000 rows of data in the gird.I would like to know that, are there validation rules for each cell with the cell properties so the user must enter in a number or a string or a particular format of each.Could I get any examples of validation using DhtmXDataProcessor.js.I would like to appreciate you if i get fast response.

Thanks.

#2

a) You can attach onEditCell event and use it for validation ( event used for any user initiated data change )

grid.attachEvent(“onEditCell”,function(stage,rid,cind,val){
    if (stage==2 && rid==ROW && cind==INDEX)
       if (!any_check(val))
          return false

    return true;
});


b) dataProcessor allow to set additional per-column validation rules but they only prevent data saving ( not visual data change ) - please refer to
    sampels/savedata_grid.html