ReferenceSequence Class
Defines the ReferenceSequence Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is xne:sqref.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.OpenXmlLeafTextElement
DocumentFormat.OpenXml.Office.Excel.ReferenceSequence
Namespace: DocumentFormat.OpenXml.Office.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class ReferenceSequence _
Inherits OpenXmlLeafTextElement
'Usage
Dim instance As ReferenceSequence
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class ReferenceSequence : OpenXmlLeafTextElement
Remarks
2.4.3 sqref
Target namespace: https://schemas.microsoft.com/office/excel/2006/main
Referenced by: CT_ConditionalFormatting, CT_DataValidation, CT_Sparkline, CT_ProtectedRange, CT_IgnoredError
A ST_Sqref that specifies a list of cell references.
An application can adjust these cell references when the worksheet layout changes, even when the containing ext ([ISO/IEC-29500-1] section 18.2.7) element is not recognized by the application. See [ISO/IEC-29500-3] section 10.1.2 for more information on how extension lists are used.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="sqref" type="ST_Sqref"/>
See section 5.2 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.7.2 ST_Sqref
Target namespace: https://schemas.microsoft.com/office/excel/2006/main
Referenced by: sqref, CT_ConditionalFormatting, CT_DataValidation, CT_Sparkline, CT_ProtectedRange, CT_IgnoredError
This simple type specifies a list of cell ranges.
This simple type is identical to the ST_Sqref ([ISO/IEC-29500-1] section 18.18.76) simple type with the following exceptions:
MUST contain zero or more values of type ST_Ref*.*
If the value contains an ST_Ref of value “#REF!” then it MUST be the only value in the list.
The number of cell references in this simple type MUST be less than 2147483647.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this simple type.
<xsd:simpleType name="ST_Sqref">
<xsd:list itemType="ST_Ref"/>
</xsd:simpleType>
See section 5.2 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.