ig.excel.WorksheetProtectedRange
Dependencies
-
ig.excel.WorksheetProtectedRange
Constructor- new $.ig.excel.WorksheetProtectedRange( title:string );
Initializes a new WorksheetProtectedRange
- title
- Type:string
- The name of the range
-
hasPassword
- .hasPassword( );
Returns true if the range has a password associated with it.
-
isProtected
- .isProtected( );
Returns a boolean indicating if the range is currently locked.
Remarks
When the associated Worksheet is protected, the ranges with a password will be marked as protected until they are unprotected.
-
ranges
- .ranges( );
Returns a collection of ranges that may be edited when the worksheet is protected.
-
title
- .title( );
Returns the name of the range.
-
title
- .title( value:string );
Sets the name of the range.
- value
- Type:string
-
unprotect
- .unprotect( );
Removes the password from the range.
Remarks
Note: If the range is not currently protected (i.e. WorksheetProtectedRange.isProtected returns false) the method will not do anything.
-
worksheet
- .worksheet( );
Returns the worksheet with which the edit range is associated.