AutoFilterMode Property (IWorksheet)

Gets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Property AutoFilterMode As Boolean

'Usage
 
Dim instance As IWorksheet
Dim value As Boolean
 
instance.AutoFilterMode = value
 
value = instance.AutoFilterMode

bool AutoFilterMode {get; set;}

Property Value

true if the AutoFilter drop-down arrows are currently displayed on the sheet; otherwise, false.

Remarks

This property returns true if the drop-down arrows are currently displayed. You can set this property to false to remove the arrows, but you cannot set it to true. Use the IRange.AutoFilter method to filter a list and display the drop-down arrows.

Reference

IWorksheet Interface
IWorksheet Members