Share via

2.6.146 CT_Ref

  • Article

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

Referenced by: ref

CT_Ref is a complex type that extends ST_Ref ([ISO/IEC29500-1:2016] section 18.18.62) specifies a rectangular range.

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.

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_Ref">
   <xsd:simpleContent>
     <xsd:extension base="ST_Ref">
       <xsd:attribute name="edited" 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).