LevelReference class

Office 2013 and later

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

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

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.37 levelRef

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

A CT_LevelRef element<96> that specifies the data source reference for the currently selected label level for a chart ([ISO/IEC-29500-1] section 21.2) category axis or a chart ([ISO/IEC-29500-1] section 21.2) series title.

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="levelRef" type="CT_LevelRef"/>

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

2.5.62 CT_LevelRef

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

Referenced by: levelRef

The CT_LevelRef is a complex type that specifies the data source reference for the currently selected label level within a hierarchical set of labels for a chart ([ISO/IEC-29500-1] section 21.2) category axis or a chart series title.<130>

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 for the associated caption level. 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.

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

<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: