Spread ASP.NET 16
Spread for ASP.NET 16 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>