public final class ProtectedRange extends Object
Ranges listed here are protected only when the sheet protection is ON and the cell is flagged as being locked. If no password is specified here, then read/write permissions are automatically given to all users, regardless of additional security descriptor information. In other words, the security descriptor information (specific types of access) at the user level is only applied if a password for this range is specified.
When a password is specified, then users not listed specifically as having access should be prompted with a password.If that user supplies the correct password, then they can edit the range or cell in question.This protection is optional and can be ignored by applications that choose not to support this functionality.
Modifier and Type | Method and Description |
---|---|
ProtectedRange |
clone() |
String |
getRefersToCells()
Gets the range to be protected.
|
String |
getTitle()
Gets the
ProtectedRange title. |
void |
setPassword(String password)
Sets the
ProtectedRange password. |
void |
setRefersToCells(String value)
Sets the range to be protected.
|
void |
setTitle(String value)
Sets the
ProtectedRange title. |
String |
toString()
Returns a
String that represents this ProtectedRange instance. |
static void |
verifyRefersToCells(String value,
String paramName) |
public ProtectedRange clone()
public String getRefersToCells()
public String getTitle()
ProtectedRange
title.ProtectedRange
title.public void setPassword(String password)
ProtectedRange
password.password
- The ProtectedRange
password.public void setRefersToCells(String value)
value
- The range to be protected.public void setTitle(String value)
ProtectedRange
title.value
- The ProtectedRange
title.public String toString()
String
that represents this ProtectedRange
instance.
This method should be used primarily for debugging purposes and should be considered volatile (format of its return value might change in future versions).
toString
in class Object
String
that represents this ProtectedRange
instance.© GemBox Ltd. — All rights reserved.