ExcelSheetProtectionOption class
Represents worksheet protection options.
Constructors
Properties
- all ↔ bool
-
Allows the user to use all the Excel sheet protection options when this is set as true.
getter/setter pair
- content ↔ bool
-
Represents whether the content should be protected.
getter/setter pair
- deleteColumns ↔ bool
-
Allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked when this is set as true.
getter/setter pair
- deleteRows ↔ bool
-
Allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked when this is set as true.
getter/setter pair
- formatCells ↔ bool
-
Allows the user to format any cell on a protected worksheet when this is set as true.
getter/setter pair
- formatColumns ↔ bool
-
Allows the user to format any column on a protected worksheet when this is set as true.
getter/setter pair
- formatRows ↔ bool
-
Allows the user to format any row on a protected when this is set as true.
getter/setter pair
- hashCode → int
-
The hash code for this object.
no setterinherited
- insertColumns ↔ bool
-
Allows the user to insert columns on the protected worksheet when this is set as true.
getter/setter pair
- insertHyperlinks ↔ bool
-
Allows the user to insert hyperlinks on the worksheet when this is set as true.
getter/setter pair
- insertRows ↔ bool
-
Allows the user to insert rows on the protected worksheet when this is set as true.
getter/setter pair
- lockedCells ↔ bool
-
Represents whether the locked cells should be protected.
getter/setter pair
- objects ↔ bool
-
Represents whether the shapes should be protected.
getter/setter pair
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- scenarios ↔ bool
-
Represents whether the scenarios should be protected.
getter/setter pair
- sort ↔ bool
-
Allows the user to sort on the protected worksheet when this is set as true.
getter/setter pair
- unlockedCells ↔ bool
-
Represents whether user interface should be protected but not macros.
getter/setter pair
- useAutoFilter ↔ bool
-
Allows the user to set filters on the protected worksheet when this is set as true. Users can change filter criteria but cannot enable or disable an auto filter.
getter/setter pair
- usePivotTableAndPivotChart ↔ bool
-
Allows the user to use pivot table reports on the protected worksheet when this is set as true.
getter/setter pair
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
Static Properties
- excelSheetProtectionOption ↔ ExcelSheetProtectionOption
-
Create instances of class for sheet protection;
getter/setter pair