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. |