Spread for ASP.NET 11 Product Documentation
Locking a Column
Spread for ASP.NET 11 Product Documentation > Client-Side Scripting Reference > Scripting Overview > Some Simple Uses of Client Scripting > 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>

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page