When I went through the documentation. I came across these t

Suite and Optimus Suite 5
#1


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.

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

#2


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(“Active linkg”);
or


           
grid.cells(…).setValue(“Not active link”);<o:p></o:p>