TSheetProtectionOptions Record
Options for protecting a sheet.
Syntax
Unit: FlexCel.Core
TSheetProtectionOptions = record;
Fields
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. |
Methods
Name | Description |
---|---|
Create | Overloaded Create Create(Boolean) Create(TProtectionType) |
Operators
Name | Description |
---|---|
Equality | Adapts the = operator so it returns true when both instances have the same values. |
Inequality | Adapts the <> operator so it returns true when both instances have different values. |