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