AutoFilterConditionType complexType

Contains information about the test applied in an autofilter.

Type Information

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

Elements and Attributes

Child Elements

None.

Attributes

Attribute Type Required Description Possible Values
Operator Anonymous required Defines the test to apply in conjunction with the Value attribute.
  • Equals
  • DoesNotEqual
  • GreaterThan
  • GreaterThanOrEqual
  • LessThan
  • LessThanOrEqual
Value xsd:string required Defines the test to apply in conjunction with the Operator attribute. See external namespace.

Definition

      
<xsd:complexType name="AutoFilterConditionType" >
  <xsd:attribute name="Operator" form="qualified" use="required">
    <xsd:simpleType>
      <xsd:restriction base="xsd:string">
        <xsd:enumeration value="Equals" />
        <xsd:enumeration value="DoesNotEqual" />
        <xsd:enumeration value="GreaterThan" />
        <xsd:enumeration value="GreaterThanOrEqual" />
        <xsd:enumeration value="LessThan" />
        <xsd:enumeration value="LessThanOrEqual" />
      </xsd:restriction>
    </xsd:simpleType>
  </xsd:attribute>
  <xsd:attribute name="Value" form="qualified" type="xsd:string" use="required">
  </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