Share via

2.6.3.16 CT_FullRef

  • Article

Target namespace: http://schemas.microsoft.com/office/drawing/2012/chart

Referenced by: fullRef

CT_FullRef is a complex type that specifies the complete data source reference for a chart ([ISO/IEC29500-1:2016] section 21.2) with filtered series data.<84>

This reference is in the form of a book, sheet, and cell reference. This reference does not include the equals sign.

Child Elements:

sqref: A string element ([XMLSCHEMA2/2] section 3.2.1) that specifies the data source reference for the chart data. This reference MUST follow the ABNF grammar rules defined in Formulas ([MS-XLSX] section 2.2.2) with the following restrictions:

  • MUST follow the single-sheet-reference rule.

  • MUST NOT use the A1-relative-column and A1-relative-row rules.

  • MUST only use A1-absolute-column and A1-absolute-row.

Contains the full set of cell references for the chart, including both filtered and unfiltered data.

An application can adjust these cell references when the worksheet layout changes, even when the containing ext element ([ISO/IEC29500-1:2016] section 18.2.7) is not recognized by the application.

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

 <xsd:complexType name="CT_FullRef">
   <xsd:sequence>
     <xsd:element name="sqref" type="xsd:string" minOccurs="1" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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