SheetProtection Class

SheetProtectionlinkLink to this section

Represents sheet-level protection settings matching the XLSX sheetProtection element. When IsProtected is true, actions are blocked unless the corresponding Allow property is true.

Declaration

public SheetProtection()

AlgorithmNamelinkLink to this section

Gets or sets the hash algorithm name (e.g. "SHA-512").

Declaration

public string AlgorithmName { get; set; }

Property Value

AllowAutoFilterlinkLink to this section

Gets or sets whether auto-filter is allowed when the sheet is protected.

Declaration

public bool AllowAutoFilter { get; set; }

Property Value

AllowDeleteColumnslinkLink to this section

Gets or sets whether deleting columns is allowed when the sheet is protected.

Declaration

public bool AllowDeleteColumns { get; set; }

Property Value

AllowDeleteRowslinkLink to this section

Gets or sets whether deleting rows is allowed when the sheet is protected.

Declaration

public bool AllowDeleteRows { get; set; }

Property Value

AllowFormatCellslinkLink to this section

Gets or sets whether formatting cells is allowed when the sheet is protected.

Declaration

public bool AllowFormatCells { get; set; }

Property Value

AllowFormatColumnslinkLink to this section

Gets or sets whether formatting columns is allowed when the sheet is protected.

Declaration

public bool AllowFormatColumns { get; set; }

Property Value

AllowFormatRowslinkLink to this section

Gets or sets whether formatting rows is allowed when the sheet is protected.

Declaration

public bool AllowFormatRows { get; set; }

Property Value

AllowInsertColumnslinkLink to this section

Gets or sets whether inserting columns is allowed when the sheet is protected.

Declaration

public bool AllowInsertColumns { get; set; }

Property Value

AllowInsertHyperlinkslinkLink to this section

Gets or sets whether inserting hyperlinks is allowed when the sheet is protected.

Declaration

public bool AllowInsertHyperlinks { get; set; }

Property Value

AllowInsertRowslinkLink to this section

Gets or sets whether inserting rows is allowed when the sheet is protected.

Declaration

public bool AllowInsertRows { get; set; }

Property Value

AllowSelectLockedCellslinkLink to this section

Gets or sets whether selecting locked cells is allowed when the sheet is protected.

Declaration

public bool AllowSelectLockedCells { get; set; }

Property Value

AllowSelectUnlockedCellslinkLink to this section

Gets or sets whether selecting unlocked cells is allowed when the sheet is protected.

Declaration

public bool AllowSelectUnlockedCells { get; set; }

Property Value

AllowSortlinkLink to this section

Gets or sets whether sorting is allowed when the sheet is protected.

Declaration

public bool AllowSort { get; set; }

Property Value

HashValuelinkLink to this section

Gets or sets the base64-encoded password hash value.

Declaration

public string HashValue { get; set; }

Property Value

IsProtectedlinkLink to this section

Gets or sets whether sheet protection is active.

Declaration

public bool IsProtected { get; set; }

Property Value

PasswordHashlinkLink to this section

Gets or sets the legacy 16-bit password hash (4 hex characters).

Declaration

public string PasswordHash { get; set; }

Property Value

SaltValuelinkLink to this section

Gets or sets the base64-encoded salt value.

Declaration

public string SaltValue { get; set; }

Property Value

SpinCountlinkLink to this section

Gets or sets the number of hash iterations.

Declaration

public int? SpinCount { get; set; }

Property Value

IsActionBlockedlinkLink to this section

Returns true if the given action is blocked by protection.

Declaration

public bool IsActionBlocked(Documents.Spreadsheet.SheetAction action)

Parameters

Returns