Float datatype with limit on decimal places

[cijojohn]

Hi Team,

I am currently facing below issue with PQ grid. How do i set the copy of cell values on change of some other cell value due to copy paste operation. PFA screenshot.
Let us know if you have any sample code or jsfiddle.

Regards,

[paramvir]

Please check this sample code: http://jsfiddle.net/eq4qge3b/

1. For different formatting in different rows of same column, column.render is used.

2. change event is used to detect changes in certain cells, and updateRow() is used to update value of any cells.

[cijojohn]

Hi Team,

Formatting is working fine for the rows having float as dataType. But we are having diff types for each column in each row..In this case user is able to type the alphabets also. Is there way to avoid it like the case when dataType is float.

[paramvir]

you can switch column.dataType in runtime for different cells/ rows to prevent alphabets in certain cells.

Use editorBegin event.

editorBegin: function(evt, ui){
   if(ui.rowData.rank < 10)            
      ui.column.dataType='float';
   else
      ui.column.dataType='string';               
},