FormulaReference class

2.3.66 formulaRef

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

A CT_FormulaRef element (section 2.5.104) that specifies the visible data source reference for filtered out chart ([ISO/IEC-29500-1] section 21.2) series data. This element specifies the reference for the series caption or values or category labels for a chart series that is filtered out from the chart.

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="formulaRef" type="CT_FormulaRef"/>

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

2.5.104 CT_FormulaRef

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

Referenced by: formulaRef

The CT_FormulaRef complex type specifies the data source reference for a chart ([ISO/IEC-29500-1] section 21.2) with filtered series data.<164>

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 ref-nospace-expression rule.

MUST NOT use the bang-reference, bang-name, sheet-range-reference, or local-cell-reference production rules

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

MUST ONLY use A1-absolute-column and A1-absolute-row.

Contains the data source reference for the series caption or values, or category labels of a filtered out series in the chart.

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_FormulaRef">

<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).

Reference