Spread WPF Documentation
ResetLocked Method (Cell)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Cell Class : ResetLocked Method
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

Reference

Cell Class
Cell Members