Share via

2.2.5.4 AutoFilterRelationOperator

  • Article

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

Specifies the relationship between an AutoFilterCriteria element (section 2.2.4.12) contained in an ArrayOfAutoFilterCriteria (section 2.2.4.2) and the one that potentially follows it.

 <xs:simpleType name="AutoFilterRelationOperator">
   <xs:restriction base="xs:string">
     <xs:enumeration value="Nil"/>
     <xs:enumeration value="And"/>
     <xs:enumeration value="Or"/>
     <xs:enumeration value="LastCount"/>
   </xs:restriction>
 </xs:simpleType>

The following table specifies the allowable values for AutoFilterRelationOperator:

Value

Meaning

Nil

See the Relation element in the AutoFilterCriteria section.

And

See the Relation element in the AutoFilterCriteria section. The protocol server will satisfy the conditions specified both in the AutoFilterCriteria that contains this value and in the one coming after it in the ArrayOfAutoFilterCriteria.

Or

See the Relation element in the AutoFilterCriteria section. The protocol server will satisfy the conditions specified in the AutoFilterCriteria that contains this value or in the one coming after it in the ArrayOfAutoFilterCriteria.

LastCount

MUST NOT be used.