ig.excel.WorksheetProtection

Provides information about the types of changes that are disabled when the associated Worksheet is protected.

Remarks

When a Worksheet is protected, the contents of unprotected cells may be edited by the end-user. One way to unprotect a cell is to change the IWorksheetCellFormat.locked property to false. Such cells may be edited by all users. Another way to unprotect cells is using the WorksheetProtection.allowedEditRanges. This is a collection of WorksheetProtectedRange instances that define a range of cells that is optionally protected by another password. For any other cells, the Worksheet would need to be unprotected first. A Worksheet may be programatically unprotected using the Worksheet.unprotect method.

The WorksheetProtection.selectionMode property is used to control which cells the end user may select when the Worksheet has been protected. This property may be set before or after protecting a Worksheet.

Many of the other properties of this class are read-only (e.g. WorksheetProtection.allowDeletingColumns). The state of these properties are optionally set when the Worksheet is protected (e.g. using the Worksheet.protect method.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.

Copyright © 1996 - 2024 Infragistics, Inc. All rights reserved.