Enum SheetProtectionType

Namespace

Spire.Xls

Assembly

Spire.XLS.dll

Represents sheet protection flags enums.

[Flags]
public enum SheetProtectionType

Fields

All = Objects | Scenarios | FormattingCells | FormattingColumns | FormattingRows | InsertingColumns | InsertingRows | InsertingHyperlinks | DeletingColumns | DeletingRows | LockedCells | Sorting | Filtering | UsingPivotTables | UnLockedCells | Content

Allows the user to do any thing on a protected worksheet.

Content = 32768

Represents all flags

DeletingColumns = 256

True allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked.

DeletingRows = 512

True allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked.

Filtering = 4096

True allows the user to set filters on the protected worksheet. Users can change filter criteria but can not enable or disable an auto filter.

FormattingCells = 4

True allows the user to format any cell on a protected worksheet.

FormattingColumns = 8

True allows the user to format any column on a protected worksheet.

FormattingRows = 16

True allows the user to format any row on a protected.

InsertingColumns = 32

True allows the user to insert columns on the protected worksheet.

InsertingHyperlinks = 128

True allows the user to insert hyperlinks on the worksheet.

InsertingRows = 64

True allows the user to insert rows on the protected worksheet.

LockedCells = 1024

True allows the user to select locked cells on the protected worksheet.

None = 0

Not allows the user to do any thing on a protected worksheet.

Objects = 1

True to protect shapes.

Scenarios = 2

True to protect scenarios.

Sorting = 2048

True allows the user to sort on the protected worksheet.

UnLockedCells = 16384

True allows the user to select locked cells on the protected worksheet.

UsingPivotTables = 8192

True allows the user to use pivot table reports on the protected worksheet.