Enum ExcelSheetProtection
Represents sheet protection flags enums.
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
[Flags]
public enum ExcelSheetProtection
Fields
Name | Description |
---|---|
All | Represents all flags |
Content | True to protect content. |
DeletingColumns | True allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked. |
DeletingRows | True allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked. |
Filtering | 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 | True allows the user to format any cell on a protected worksheet. |
FormattingColumns | True allows the user to format any column on a protected worksheet. |
FormattingRows | True allows the user to format any row on a protected. |
InsertingColumns | True allows the user to insert columns on the protected worksheet. |
InsertingHyperlinks | True allows the user to insert hyperlinks on the worksheet. |
InsertingRows | True allows the user to insert rows on the protected worksheet. |
LockedCells | True to protect locked cells. |
None | Represents none flags. |
Objects | True to protect shapes. |
Scenarios | True to protect scenarios. |
Sorting | True allows the user to sort on the protected worksheet. |
UnLockedCells | True to protect the user interface, but not macros. |
UsingPivotTables | True allows the user to use pivot table reports on the protected worksheet. |