AutoFilterColumnType complexType

Contains the autofilter criteria for a column in an autofilter range.

Type Information

Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Child Elements

Element Description
AutoFilterCondition Contains information about the test applied in an autofilter.
AutoFilterOr Contains an autofilter condition that can be combined with other conditions using the OR operator.
AutoFilterCondition Specifies the criteria for the autofilter.
AutoFilterAnd Contains an autofilter condition that can be combined with other conditions using the AND operator.
AutoFilterCondition Specifies the criteria for the autofilter.

Attributes

Attribute Type Required Description Possible Values
Index xsd:integer optional Specifies the column in the autofilter range to which the current autofilter applies. See external namespace.
Type Anonymous required Specifies the type of autofilter to apply to the column.
  • Top
  • Bottom
  • TopPercent
  • BottomPercent
  • Custom
Value xsd:integer optional Contains a value for the autofilter condition specified in the Type attribute. See external namespace.

Definition

      
<xsd:complexType name="AutoFilterColumnType" >
  <xsd:sequence>
    <xsd:choice>
      <xsd:element name="AutoFilterCondition" type="AutoFilterConditionType" minOccurs="0" maxOccurs="1">
      </xsd:element>
      <xsd:element name="AutoFilterOr" minOccurs="0" maxOccurs="1">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element name="AutoFilterCondition" type="AutoFilterConditionType" minOccurs="2" maxOccurs="2">
            </xsd:element>
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
      <xsd:element name="AutoFilterAnd" minOccurs="0" maxOccurs="1">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element name="AutoFilterCondition" type="AutoFilterConditionType" minOccurs="2" maxOccurs="2">
            </xsd:element>
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:choice>
  </xsd:sequence>
  <xsd:attribute name="Index" type="xsd:integer" use="optional" form="qualified">
  </xsd:attribute>
  <xsd:attribute name="Type" use="required" form="qualified">
    <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 name="Value" type="xsd:integer" use="optional" form="qualified">
  </xsd:attribute>
</xsd:complexType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp