2.6.64 CT_ListItems

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_FormControlPr

A complex type that contains a list of items of type CT_ListItem, as specified in section 2.6.63, to populate a list box or a drop-down form control. When present, the FmlaRange attribute of CT_FormControlPr, as specified in section 2.6.65, takes precedence over this element. This element is valid only for list box and drop-down form control.

Child Elements:

item: A CT_ListItem element that contains a single data item for a list box or drop-down form control.

extLst: A CT_ExtensionList element, as specified in ([ISO/IEC29500-4:2016] section A.2, that specifies future extensibility for this element.

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

 <xsd:complexType name="CT_ListItems">
   <xsd:sequence>
     <xsd:element name="item" type="CT_ListItem" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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