API Reference
ExcelSheetProtectionOptions
Options controlling worksheet protection behavior.
Inheritance
- Object
- ExcelSheetProtectionOptions
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
Accepted by parameters
- Method ExcelSheet.Protect
Constructors
public ExcelSheetProtectionOptions() #Methods
public static ExcelSheetProtectionOptions TableEditing(String password = null) #ExcelSheetProtectionOptionsCreates protection options that keep the sheet protected while allowing common table editing workflows.
Parameters
- password System.String = null
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public Boolean AllowSelectLockedCells { get; set; } #Allow selecting locked cells.
public Boolean AllowSelectUnlockedCells { get; set; } #Allow selecting unlocked cells.
public Boolean AllowFormatCells { get; set; } #Allow formatting cells.
public Boolean AllowFormatColumns { get; set; } #Allow formatting columns.
public Boolean AllowFormatRows { get; set; } #Allow formatting rows.
public Boolean AllowInsertColumns { get; set; } #Allow inserting columns.
public Boolean AllowInsertRows { get; set; } #Allow inserting rows.
public Boolean AllowInsertHyperlinks { get; set; } #Allow inserting hyperlinks.
public Boolean AllowDeleteColumns { get; set; } #Allow deleting columns.
public Boolean AllowDeleteRows { get; set; } #Allow deleting rows.
public Boolean AllowSort { get; set; } #Allow sorting.
public Boolean AllowAutoFilter { get; set; } #Allow AutoFilter.
public Boolean AllowPivotTables { get; set; } #Allow PivotTables.
public Nullable<Boolean> ProtectObjects { get; set; } #Protect worksheet drawing objects when set. When null, the objects attribute is omitted.
public Nullable<Boolean> ProtectScenarios { get; set; } #Protect worksheet scenarios when set. When null, the scenarios attribute is omitted.
public String Password { get; set; } #Optional worksheet protection password. This is Excel UI protection, not package encryption.
public String LegacyPasswordHash { get; set; } #Optional precomputed legacy worksheet protection hash. When set, this value is written as-is.