Spread.Services Documentation
AutoFilter Method
GrapeCity.Documents.Spread Namespace > IRange Interface : AutoFilter Method
Optional Object. The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field one).
Optional Object. The criteria (a string; for example, "101"). Use "=" to find blank fields, or use "]]>" to find nonblank fields. If this argument is omitted, the criteria is All. If Operator is xlTop10Items, Criteria1 specifies the number of items (for example, "10").
Optional AutoFilterOperator
Optional Object. The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
Optional Object. True to display the AutoFilter drop-down arrow for the filtered field; False to hide the AutoFilter drop-down arrow for the filtered field. True by default.
Filters a list using the AutoFilter.
Syntax
void AutoFilter( 
   System.int field,
   System.object criteria1,
   AutoFilterOperator op,
   System.object criteria2,
   System.bool visibleDropDown
)

Parameters

field
Optional Object. The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field one).
criteria1
Optional Object. The criteria (a string; for example, "101"). Use "=" to find blank fields, or use "]]>" to find nonblank fields. If this argument is omitted, the criteria is All. If Operator is xlTop10Items, Criteria1 specifies the number of items (for example, "10").
op
Optional AutoFilterOperator
criteria2
Optional Object. The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
visibleDropDown
Optional Object. True to display the AutoFilter drop-down arrow for the filtered field; False to hide the AutoFilter drop-down arrow for the filtered field. True by default.
See Also

Reference

IRange Interface
IRange Members