Locking a Column | Spread ASP.NET 18

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

Spread for ASP.NET 18 Product Documentation

Locking a Column

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>