- FlexSheet for WPF Overview
- FlexSheet Key Features
- Quick Start: FlexSheet for WPF
- Customizing Appearance
-
Working with C1FlexSheet
- Inserting Worksheets in FlexSheet
-
Sheet Operations
- Inserting and Deleting Rows and Columns
- Filtering Columns
- Using Find and Replace
- Keyboard Navigation
- Tab Navigation
- Drag and Drop Rows or Columns
- Data Binding
- Data Validation
- Freezing and Unfreezing Rows and Columns
- Grouping and Ungrouping Rows
- Removing Duplicate Rows
- Protect Sheets and Cell Locking
- Sheet Renaming
- Sheet Reordering
- Sorting Columns
- Undo Redo Operations
- Cell Operations
- Importing and Exporting
- Using Formulas
- Printing Data
Protect Sheets and Cell Locking
You can protect sheets and lock cells in FlexSheet for WPF. IsProtected property is used to protect sheets in C1FlexSheet control. The following code illustrates the use of IsProtected property:
vbnet
protectedSheet.IsProtected = True
csharp
protectedSheet.IsProtected = true;
AddLockedCell method can be used to lock cells in C1FlexSheet control. The AddLockedCell method locks the specified cell range, as illustrated in the following code:
vbnet
protectedSheet.AddLockedCell(0, 0, 1, 1)
csharp
protectedSheet.AddLockedCell(0, 0, 1, 1);