ExcelSheetProtection Class
Represents sheet protection flags enums.
Inheritance
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public sealed class ExcelSheetProtection : EnumFields
All
Represents all flags
Declaration
public const ExcelSheetProtection AllField Value
| Type |
|---|
| ExcelSheetProtection |
Content
True to protect content.
Declaration
public const ExcelSheetProtection ContentField 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 DeletingColumnsField 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 DeletingRowsField 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 FilteringField Value
| Type |
|---|
| ExcelSheetProtection |
FormattingCells
True allows the user to format any cell on a protected worksheet.
Declaration
public const ExcelSheetProtection FormattingCellsField Value
| Type |
|---|
| ExcelSheetProtection |
FormattingColumns
True allows the user to format any column on a protected worksheet.
Declaration
public const ExcelSheetProtection FormattingColumnsField Value
| Type |
|---|
| ExcelSheetProtection |
FormattingRows
True allows the user to format any row on a protected.
Declaration
public const ExcelSheetProtection FormattingRowsField Value
| Type |
|---|
| ExcelSheetProtection |
InsertingColumns
True allows the user to insert columns on the protected worksheet.
Declaration
public const ExcelSheetProtection InsertingColumnsField Value
| Type |
|---|
| ExcelSheetProtection |
InsertingHyperlinks
True allows the user to insert hyperlinks on the worksheet.
Declaration
public const ExcelSheetProtection InsertingHyperlinksField Value
| Type |
|---|
| ExcelSheetProtection |
InsertingRows
True allows the user to insert rows on the protected worksheet.
Declaration
public const ExcelSheetProtection InsertingRowsField Value
| Type |
|---|
| ExcelSheetProtection |
LockedCells
True to protect locked cells.
Declaration
public const ExcelSheetProtection LockedCellsField Value
| Type |
|---|
| ExcelSheetProtection |
None
Represents none flags.
Declaration
public const ExcelSheetProtection NoneField Value
| Type |
|---|
| ExcelSheetProtection |
Objects
True to protect shapes.
Declaration
public const ExcelSheetProtection ObjectsField Value
| Type |
|---|
| ExcelSheetProtection |
Scenarios
True to protect scenarios.
Declaration
public const ExcelSheetProtection ScenariosField Value
| Type |
|---|
| ExcelSheetProtection |
Sorting
True allows the user to sort on the protected worksheet.
Declaration
public const ExcelSheetProtection SortingField Value
| Type |
|---|
| ExcelSheetProtection |
UnLockedCells
True to protect the user interface, but not macros.
Declaration
public const ExcelSheetProtection UnLockedCellsField Value
| Type |
|---|
| ExcelSheetProtection |
UsingPivotTables
True allows the user to use pivot table reports on the protected worksheet.
Declaration
public const ExcelSheetProtection UsingPivotTablesField Value
| Type |
|---|
| ExcelSheetProtection |