Share via

2.7.2 ST_Sqref

  • Article

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

Referenced by: CT_Sqref

This simple type specifies a list of cell ranges.

This simple type is identical to the ST_Sqref ([ISO/IEC29500-1:2016] section 18.18.76) simple type with the following exceptions:

  • MUST contain zero or more values of type ST_Ref.

  • If the value contains an ST_Ref of value "#REF!", then it MUST be the only value in the list.

  • The number of cell references in this simple type MUST be less than 2,147,483,647.

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

 <xsd:simpleType name="ST_Sqref">
   <xsd:list itemType="ST_Ref"/>
 </xsd:simpleType>

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