Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Defines the ProtectedRanges Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:protectedRanges.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.ProtectedRanges
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(ProtectedRange), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class ProtectedRanges _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As ProtectedRanges
[ChildElementInfoAttribute(typeof(ProtectedRange), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class ProtectedRanges : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- ProtectedRange <x14:protectedRange>
2.4.8 protectedRanges
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
A CT_ProtectedRanges element that specifies a group of protected ranges on the sheet. See Worksheet under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="protectedRanges" type="CT_ProtectedRanges"/>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.55 CT_ProtectedRanges
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: protectedRanges
A complex type that specifies a group of protected ranges on the sheet. MUST contain fewer than 231 elements.
Child Elements:
protectedRange : A CT_ProtectedRange element that specifies the properties for a single protected range.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_ProtectedRanges">
<xsd:sequence>
<xsd:element name="protectedRange" type="CT_ProtectedRange" minOccurs="1" maxOccurs="unbounded"/>
</xsd:sequence>
</xsd:complexType>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.