Share via

2.7.1 ST_Ref

  • Article

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

Referenced by: CT_Ref, ST_Sqref

This simple type specifies a reference to a range of cells.

This simple type is identical to the ST_Ref ([ISO/IEC29500-1:2016] section 18.18.62) simple type with the following exception: This simple type MUST have the following grammar.

 (A1-cell [":" A1-cell])  / ref-constant

The ABNF ([RFC5234]) definitions for A1-cell and ref-constant are specified in Formulas.

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

 <xsd:simpleType name="ST_Ref">
   <xsd:restriction base="xsd:string"/>
 </xsd:simpleType>

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