officefileapi-devexpress-dot-spreadsheet-dot-worksheet-ad556799.md
Gets whether the worksheet is protected.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool IsProtected { get; }
ReadOnly Property IsProtected As Boolean
| Type | Description |
|---|---|
| Boolean |
true , if the worksheet is protected; otherwise, false.
|
Use the IsProtected property to check whether the worksheet is already protected before applying protection with the Worksheet.Protect method.
The following code snippets (auto-collected from DevExpress Examples) contain references to the IsProtected property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
// Protect the worksheet with a password.
if (!worksheet.IsProtected)
worksheet.Protect("password", WorksheetProtectionPermissions.Default);
// Protect a worksheet. Prevent users from making changes to worksheet elements.
if (!worksheet.IsProtected)
worksheet.Protect("password", WorksheetProtectionPermissions.Default);
// Prevent users from making changes to worksheet elements
if (!worksheet.IsProtected)
worksheet.Protect("password", WorksheetProtectionPermissions.Default);
' Protect the worksheet with a password.
If Not worksheet.IsProtected Then
worksheet.Protect("password", WorksheetProtectionPermissions.Default)
' Protect a worksheet. Prevent users from making changes to worksheet elements.
If Not worksheet.IsProtected Then
worksheet.Protect("password", WorksheetProtectionPermissions.Default)
' Prevent users from making changes to worksheet elements
If Not worksheet.IsProtected Then
worksheet.Protect("password", WorksheetProtectionPermissions.Default)
See Also