You can use client-side scripting in Spread to lock a column using code similar to this example. 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> |