Aspose.Cells FOSS

WorksheetProtection

WorksheetProtection

Overview

WorksheetProtection is a class in Aspose.Cells for NET.

WorksheetProtection.IsProtected indicates whether the worksheet is currently protected.

Properties

Name	Type	Access	Description
`IsProtected`	`bool`	Read/Write	Indicates whether the worksheet is currently protected
`Objects`	`bool`	Read/Write	Specifies if objects (e.g., charts, shapes) can be edited when protected
`Scenarios`	`bool`	Read/Write	Determines whether scenario manager actions are allowed under protection
`FormatCells`	`bool`	Read/Write	Controls whether cell formatting is allowed when the sheet is protected
`FormatColumns`	`bool`	Read/Write	Indicates if column formatting is permitted while the worksheet is protected
`FormatRows`	`bool`	Read/Write	Indicates if row formatting is permitted when the worksheet is protected
`InsertColumns`	`bool`	Read/Write	Specifies whether new columns may be inserted in a protected worksheet
`InsertRows`	`bool`	Read/Write	Specifies whether new rows may be inserted when the sheet is protected
`InsertHyperlinks`	`bool`	Read/Write	Determines if hyperlinks can be added while the worksheet is protected
`DeleteColumns`	`bool`	Read/Write	Controls whether columns can be deleted from a protected worksheet
`DeleteRows`	`bool`	Read/Write	Controls whether rows can be deleted when the worksheet is protected
`SelectLockedCells`	`bool`	Read/Write	Controls if locked cells can be selected when the sheet is protected
`Sort`	`bool`	Read/Write	Determines whether sorting operations are allowed while the worksheet is protected
`AutoFilter`	`bool`	Read/Write	Specifies if auto‑filter functionality is permitted when the sheet is protected
`PivotTables`	`bool`	Read/Write	Indicates whether pivot tables can be used or modified while protected
`SelectUnlockedCells`	`bool`	Read/Write	Indicates if unlocked cells may be selected when the worksheet is protected