Spread WPF 15
Spread WPF Documentation / Developer's Guide / Managing the User Interface / Using Protect and Cell Locking
In This Topic
    Using Protect and Cell Locking
    In This Topic

    You can protect the workbook or sheet and lock cells in the control.

    Cells can still be edited if the workbook Protect property is true and the worksheet Protect property is false.

    Protecting the workbook and sheet prevents cells from being edited. If you wish to allow the user to edit specific cells, protect the sheet and unlock only the cells you want the user to edit.

    Data can be copied from locked cells.

    Using Code

    The following example unlocks cells in a protected sheet with the Locked property.

    CS
    Copy Code
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Locked = false;
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "Locked";
    gcSpreadSheet1.Sheets[0].Columns[3].Locked = false;
    gcSpreadSheet1.Sheets[0].Rows[5].Locked = false;
    gcSpreadSheet1.Protect = true;
    gcSpreadSheet1.Sheets[0].Protect = true;
    gcSpreadSheet1.Invalidate();
    private void button1_Click(object sender, RoutedEventArgs e)
            {
    gcSpreadSheet1.Sheets[0].Cells[1, 1].ResetLocked();
    gcSpreadSheet1.Invalidate();
            }
    
    VB.NET
    Copy Code
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Locked = False
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Text = "Locked"
    GcSpreadSheet1.Sheets(0).Columns(3).Locked = False
    GcSpreadSheet1.Sheets(0).Rows(5).Locked = False
    GcSpreadSheet1.Protect = True
    GcSpreadSheet1.Sheets(0).Protect = True
    GcSpreadSheet1.Invalidate()
    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
    GcSpreadSheet1.Sheets(0).Cells(1, 1).ResetLocked()
    GcSpreadSheet1.Invalidate()
    End Sub
    
    See Also