Spread ASP.NET 17
Spread for ASP.NET 17 Product Documentation / Client-Side Scripting Reference / Scripting Overview / Some Simple Uses of Client Scripting / Locking a Column
In This Topic
    Locking a Column
    In This Topic

    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>