SheetProtectionOption enum Worksheet

An action a user may be permitted to perform on a protected sheet.

Pass the ones you want to allow to Sheet.protect; everything not listed stays locked. Selecting cells is always permitted (Excel's default).

Inheritance
Available extensions

Values

formatCells → const SheetProtectionOption

Format any cell.

formatColumns → const SheetProtectionOption

Change column width / hide columns.

formatRows → const SheetProtectionOption

Change row height / hide rows.

insertColumns → const SheetProtectionOption

Insert columns.

insertRows → const SheetProtectionOption

Insert rows.

Insert hyperlinks.

deleteColumns → const SheetProtectionOption

Delete columns.

deleteRows → const SheetProtectionOption

Delete rows.

sort → const SheetProtectionOption

Sort ranges.

autoFilter → const SheetProtectionOption

Use existing autofilters.

pivotTables → const SheetProtectionOption

Use PivotTables / PivotCharts.

editObjects → const SheetProtectionOption

Edit drawing objects.

editScenarios → const SheetProtectionOption

Edit scenarios.

Properties

hashCode → int
The hash code for this object.
no setterinherited
index → int
A numeric identifier for the enumerated value.
no setterinherited
name → String

Available on Enum, provided by the EnumName extension

The name of the enum value.
no setter
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited

Constants

values → const List<SheetProtectionOption>
A constant List of the values in this enum, in order of their declaration.