menu

ASP.NET Core

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Enum ExcelSheetProtection

    Show / Hide Table of Contents

    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.

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved