Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Cell Class / ResetLocked Method
Example


In This Topic
    ResetLocked Method (Cell)
    In This Topic
    Resets the locked state for the cell and causes the cell to inherit the locked state from the default cell.
    Syntax
    'Declaration
     
    Public Sub ResetLocked() 
    'Usage
     
    Dim instance As Cell
     
    instance.ResetLocked()
    public void ResetLocked()
    Example
    This example only allows certain cells to be edited.
    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();
            }
    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