You can use the SetLocked method to lock a column on the client side.
You can also use attributes to lock a column. The following code locks and unlocks column 1 on the client side.
JavaScript |
Copy Code
|
---|---|
<script language="javascript"> function unlockCol() { var span = FpSpread1.all("FpSpread1_view"); var table = span.firstChild; var tr; for (var j = 1;j<=FpSpread1.GetRowCount();j++) { tr = table.rows(j); tc = tr.cells(1); tc.removeAttribute("FpCellType"); } } function lockCol() { var span = FpSpread1.all("FpSpread1_view"); var table = span.firstChild; var tr; for (var j = 1;j<=FpSpread1.GetRowCount();j++) { tr= table.rows(j); tc = tr.cells(1) tc.setAttribute("FpCellType","readonly"); } } </script> |