<xsd:complexType xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="AutoFilterColumnType" >
  <xsd:annotation>
    <xsd:documentation>Contains the autofilter criteria for a column in an autofilter range.</xsd:documentation>
  </xsd:annotation>
  <xsd:sequence>
    <xsd:choice>
      <xsd:element minOccurs="0" maxOccurs="1" name="AutoFilterCondition" type="AutoFilterConditionType">
        <xsd:annotation>
          <xsd:documentation>Contains information about the test applied in an autofilter.</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element minOccurs="0" maxOccurs="1" name="AutoFilterOr">
        <xsd:annotation>
          <xsd:documentation>Contains an autofilter condition that can be combined with other conditions using the OR operator.</xsd:documentation>
        </xsd:annotation>
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element minOccurs="2" maxOccurs="2" name="AutoFilterCondition" type="AutoFilterConditionType">
              <xsd:annotation>
                <xsd:documentation>Specifies the criteria for the autofilter.</xsd:documentation>
              </xsd:annotation>
            </xsd:element>
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
      <xsd:element minOccurs="0" maxOccurs="1" name="AutoFilterAnd">
        <xsd:annotation>
          <xsd:documentation>Contains an autofilter condition that can be combined with other conditions using the AND operator.</xsd:documentation>
        </xsd:annotation>
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element minOccurs="2" maxOccurs="2" name="AutoFilterCondition" type="AutoFilterConditionType">
              <xsd:annotation>
                <xsd:documentation>Specifies the criteria for the autofilter.</xsd:documentation>
              </xsd:annotation>
            </xsd:element>
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:choice>
  </xsd:sequence>
  <xsd:attribute form="qualified" name="Index" type="xsd:integer" use="optional">
    <xsd:annotation>
      <xsd:documentation>Specifies the column in the autofilter range to which the current autofilter applies.</xsd:documentation>
    </xsd:annotation>
  </xsd:attribute>
  <xsd:attribute form="qualified" name="Type" use="required">
    <xsd:annotation>
      <xsd:documentation>Specifies the type of autofilter to apply to the column.</xsd:documentation>
    </xsd:annotation>
    <xsd:simpleType>
      <xsd:restriction base="xsd:string">
        <xsd:enumeration value="Top"/>
        <xsd:enumeration value="Bottom"/>
        <xsd:enumeration value="TopPercent"/>
        <xsd:enumeration value="BottomPercent"/>
        <xsd:enumeration value="Custom"/>
      </xsd:restriction>
    </xsd:simpleType>
  </xsd:attribute>
  <xsd:attribute form="qualified" name="Value" type="xsd:integer" use="optional">
    <xsd:annotation>
      <xsd:documentation>Contains a value for the autofilter condition specified in the Type attribute.</xsd:documentation>
    </xsd:annotation>
  </xsd:attribute>
</xsd:complexType>