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