AutoFilterColumn element

Contains information about the column being filtered.

Usage

      
<AutoFilterColumn
	Index="xsd:integer"
	Type="xsd:string"
	Value="xsd:integer"
/>

    

Element Information

Element type AutoFilterColumnType
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:element name="AutoFilterColumn" type="AutoFilterColumnType" >
</xsd:element>


    
©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