FullReference class

Office 2013 and later

Defines the FullReference Class.This class is only available in Office2013. When the object is serialized out as xml, its qualified name is c15:fullRef.

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2013.Drawing.Chart.FullReference

Namespace:  DocumentFormat.OpenXml.Office2013.Drawing.Chart
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

2.3.36 fullRef

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

A CT_FullRef element<95> that specifies the non-filtered data source reference for filtered out chart ([ISO/IEC-29500-1] section 21.2) series data.

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

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="fullRef" type="CT_FullRef"/>

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

2.5.61 CT_FullRef

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/IEC-29500-1] section 21.2) with filtered series data.<129>

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] 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/IEC-29500-1] section 18.2.7) is not recognized by the application.

The following W3C XML Schema ([XMLSCHEMA1] 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] section 2.1).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: