Start Building Professional
Web Apps Today

When I went through the documentation. I came across these three methods

mygrid.setRowExcellType(rowId,type);//sets all cells in row to specified type

mygrid.setCellExcellType(rowId,cellIndex,type);//sets particular cell type

mygrid.setColumnExcellType(colIndex,type);//changes column type

I tried to use this methods but I think they were not working. If u got any examples to these methods or if you can suggest me how to use this functions that will be very helpful as most of our requirements we need different column or row types depending on the some particular condition.

For example if in column 3 there is no data then corresponding rows column one should not be shown as hyperlink.

Please check samples/pro_col_excell.html All methods setRowExcellType, setCellExcellType, setColumnExcellType is definitely working ( pro version only )

 For example if in column 3 there is no data then corresponding rows column one should not be shown as hyperlink.

 But when I am creating a grid I have defined column one as link type. How to go about this issues.

This can be done this combination of onEdit event handler ( to catch empty cells ) and setCellExcellType commands.

Basically it can be done without setCellExcellType - you can define exCell type as "ro" and just provide necessary value HTML (because ro treats value as HTML you can

            grid.cells(...).setValue("<a href=''>Active linkg</a>"); or

            grid.cells(...).setValue("Not active link");

To find more precise comments upon this issue, we can offer you read about gantt chat and calendar picker in javascript.