2.3.50 ST_enmCellSpanType

  • Article

Referenced by: CT_Cell

Specifies the reason why a worksheet cell occupies more than one row or column.

The following table shows the enumeration values for this type.

Value

Meaning

Merge

The worksheet cell is part of a merged range.

Spill

Specified when all of the following conditions are met:

  • The worksheet cell’s contents do not fit within the bounds specified by its column width.

  • The adjacent cell is empty.

None

Represents an invalid or uninitialized value. MUST NOT be used.

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

 <xs:simpleType name="ST_enmCellSpanType">
   <xs:restriction base="xs:string">
     <xs:enumeration value="Merge"/>
     <xs:enumeration value="Spill"/>
     <xs:enumeration value="None"/>
   </xs:restriction>
 </xs:simpleType>

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