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

• Object
• Enum
• SheetProtectionOption

Available extensions

• EnumName

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.

insertHyperlinks → const SheetProtectionOption

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 setter, inherited

index → int

A numeric identifier for the enumerated value.

no setter, inherited

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 setter, inherited

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.