Share via

2.6.147 CT_Sqref

  • Article

Target namespace: http://schemas.microsoft.com/office/excel/2006/main

Referenced by: sqref, CT_ConditionalFormatting, CT_DataValidation, CT_Sparkline, CT_IgnoredError, CT_ProtectedRange

CT_Sqref is a complex type that extends ST_Sqref ([ISO/IEC29500-1:2016] section 18.18.76) specifies a sequence of cell references.

Attributes:

edited:  A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies that at least one cell in this range has been edited by an application version that is unable to read one or more ancestor records.

split: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies that this range has been split.

adjusted:  A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this range has been adjusted by an application version that is unable to read one or more ancestor records.

adjust: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether application versions that are unable to read one or more ancestor records will adjust this range if the contents of the cells that this range refers to are changed. MUST be TRUE if adjusted is TRUE.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_Sqref">
   <xsd:simpleContent>
     <xsd:extension base="ST_Sqref">
       <xsd:attribute name="edited" type="xsd:boolean" use="optional"/>
       <xsd:attribute name="split" type="xsd:boolean" use="optional"/>
       <xsd:attribute name="adjusted" type="xsd:boolean" use="optional"/>
       <xsd:attribute name="adjust" type="xsd:boolean" use="optional"/>
     </xsd:extension>
   </xsd:simpleContent>
 </xsd:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).