Click or drag to resize

SheetProtection Properties

The SheetProtection type exposes the following members.

Properties
 NameDescription
Public propertyAlgorithmName

Cryptographic Algorithm Name

Represents the following attribute in the schema: algorithmName

Public propertyAutoFilter

AutoFilter Locked

Represents the following attribute in the schema: autoFilter

Public propertyChildElements Gets all the child nodes of the current element.
(Inherited from OpenXmlElement)
Public propertyDeleteColumns

Delete Columns Locked

Represents the following attribute in the schema: deleteColumns

Public propertyDeleteRows

Delete Rows Locked

Represents the following attribute in the schema: deleteRows

Public propertyExtendedAttributes Gets all extended attributes (attributes not defined in the schema) of the current element.
(Inherited from OpenXmlElement)
Public propertyFeatures Gets a IFeatureCollection for the current element. This feature collection will be read-only, but will inherit features from its parent part and package if available.
(Inherited from OpenXmlElement)
Public propertyFirstChild Gets the first child of the OpenXmlElement element. Returns null (Nothing in Visual Basic) if there is no such OpenXmlElement element.
(Inherited from OpenXmlElement)
Public propertyFormatCells

Format Cells Locked

Represents the following attribute in the schema: formatCells

Public propertyFormatColumns

Format Columns Locked

Represents the following attribute in the schema: formatColumns

Public propertyFormatRows

Format Rows Locked

Represents the following attribute in the schema: formatRows

Public propertyHasAttributes Gets a value indicating whether the current element has any attributes.
(Inherited from OpenXmlElement)
Public propertyHasChildren Gets a value indicating whether the current element has any child elements.
(Inherited from OpenXmlLeafElement)
Public propertyHashValue

Password Hash Value

Represents the following attribute in the schema: hashValue

Public propertyInnerText Gets or sets the concatenated values of the node and all of its children.
(Inherited from OpenXmlElement)
Public propertyInnerXml Gets or sets the markup that represents only the child elements of the current element.
(Inherited from OpenXmlLeafElement)
Public propertyInsertColumns

Insert Columns Locked

Represents the following attribute in the schema: insertColumns

Public propertyInsertHyperlinks

Insert Hyperlinks Locked

Represents the following attribute in the schema: insertHyperlinks

Public propertyInsertRows

Insert Rows Locked

Represents the following attribute in the schema: insertRows

Public propertyLastChild Gets the last child of the OpenXmlElement element. Returns null (Nothing in Visual Basic) if there is no such OpenXmlElement element.
(Inherited from OpenXmlElement)
Public propertyLocalName Gets the local name of the current element.
(Inherited from OpenXmlElement)
Public propertyMCAttributes Gets or sets the markup compatibility attributes. Returns null if no markup compatibility attributes are defined for the current element.
(Inherited from OpenXmlElement)
Public propertyNamespaceDeclarations Gets all the namespace declarations defined in the current element. Returns an empty enumerator if there is no namespace declaration.
(Inherited from OpenXmlElement)
Public propertyNamespaceUri Gets the namespace URI of the current element.
(Inherited from OpenXmlElement)
Public propertyObjects

Objects Locked

Represents the following attribute in the schema: objects

Public propertyOpenXmlElementContext Gets the OpenXmlElementContext of the current element.
(Inherited from OpenXmlElement)
Public propertyOuterXml Gets the markup that represents the current element and all of its child elements.
(Inherited from OpenXmlElement)
Public propertyParent Gets the parent element of the current element.
(Inherited from OpenXmlElement)
Public propertyPassword

Password

Represents the following attribute in the schema: password

Public propertyPivotTables

Pivot Tables Locked

Represents the following attribute in the schema: pivotTables

Public propertyPrefix Gets the namespace prefix of current element.
(Inherited from OpenXmlElement)
Public propertySaltValue

Salt Value for Password Verifier

Represents the following attribute in the schema: saltValue

Public propertyScenarios

Scenarios Locked

Represents the following attribute in the schema: scenarios

Public propertySelectLockedCells

Select Locked Cells Locked

Represents the following attribute in the schema: selectLockedCells

Public propertySelectUnlockedCells

Select Unlocked Cells Locked

Represents the following attribute in the schema: selectUnlockedCells

Public propertySheet

Sheet Locked

Represents the following attribute in the schema: sheet

Public propertySort

Sort Locked

Represents the following attribute in the schema: sort

Public propertySpinCount

Iterations to Run Hashing Algorithm

Represents the following attribute in the schema: spinCount

Public propertyXmlQualifiedName Gets the qualified name of the current element.
(Inherited from OpenXmlElement)
Public propertyXName Gets the qualified name of the current element.
(Inherited from OpenXmlElement)
Top
See Also