TSheetProtectionOptions Class
Options for protecting a sheet.
Syntax
Namespace: FlexCel.Core
public sealed class TSheetProtectionOptionsConstructors
| Name | Description |
|---|---|
| TSheetProtectionOptions | Overloaded TSheetProtectionOptions TSheetProtectionOptions(Boolean) TSheetProtectionOptions(TProtectionType) |
Properties
| Name | Description |
|---|---|
| Contents | Sheet contents are protected |
| 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. |
| 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. |
| 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. |
| RowFormatting | 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. |
| InsertRows | 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. |
| 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. |
| SelectLockedCells | 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. |
| 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. |
| SelectUnlockedCells | If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP. |