TSheetProtectionOptions Class
Options for protecting a sheet.
Syntax
Namespace: FlexCel.Core
public sealed class TSheetProtectionOptionsConstructors
| Name | Description |
|---|---|
| TSheetProtection​Options | Overloaded TSheetProtectionOptions TSheetProtectionOptions(Boolean) TSheetProtectionOptions(TProtectionType) |
Properties
| Name | Description |
|---|---|
| CellFormatting | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| ColumnFormatting | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| Contents | Sheet contents are protected |
| DeleteColumns | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| DeleteRows | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| EditAutoFilters | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| EditPivotTables | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| InsertColumns | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| InsertHyperlinks | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| InsertRows | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| Objects | If TRUE, objects on the sheet are protected. Note that this setting behaves like Scenarios and opposite from all the rest. In the other settings, FALSE means that the setting is protected, TRUE that the setting can be changed. |
| RowFormatting | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| Scenarios | If TRUE, scenarios on the sheet are protected. Note that this setting behaves like Objects and opposite from all the rest. In the other settings, FALSE means that the setting is protected, TRUE that the setting can be changed. |
| SelectLockedCells | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| SelectUnlockedCells | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |
| SortCellRange | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |