AutoFilterMode Property

In This Topic

Gets or sets the AutoFilterMode which indicates which filtering UI is used.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AutoFilterMode As AutoFilterMode

'Usage
 
Dim instance As SheetView
Dim value As AutoFilterMode
 
instance.AutoFilterMode = value
 
value = instance.AutoFilterMode

public AutoFilterMode AutoFilterMode {get; set;}

Remarks

Note: In versions earlier than V7, if you set the SheetView.RowFilter to a HideRowFilter, the label of the header cell in the filter column (specified through FilterColumnDefinition) changed to the "FilterBy" string (if the column is not filtered, the "(All)" string is displayed). In version 7, specify the AutoFilterMode (if your mode differs from the default mode FilterGadget) before you set a HideRowFilter to SheetView.

Example

This example sets the AutoFilterMode property.

VB.NET

Reference

SheetView Class
SheetView Members

Product Support Forum | Print this page