AutoFilterIndex Property (ColumnHeader)

Gets or sets which column header row displays the row filter indicator when there are multiple column header rows.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AutoFilterIndex As Integer

'Usage
 
Dim instance As ColumnHeader
Dim value As Integer
 
instance.AutoFilterIndex = value
 
value = instance.AutoFilterIndex

public int AutoFilterIndex {get; set;}

Property Value

Integer number representing the zero-based row index

Remarks

If your header has multiple column header rows, you can specify which row displays the filtering indicator by setting this property. To specify the index, set the property to a value between 0 and n-1, where 0 is the top row and n is the number of header rows. Any value above n-1 simply puts the filtering indicator in the bottom row.

For best results set the RowCount property before setting the AutoFilterIndex property.

This property does not have an effect unless the Visible property (or the SheetView ColumnHeaderVisible property) is set to true and the column header rows are not hidden.

Example

This examples shows the use of the property to select the second row down from the top (the top being zero).

FpSpread1.ActiveSheetView.ColumnHeader.AutoFilterIndex = 1;

Visual Basic

FpSpread1.ActiveSheetView.ColumnHeader.AutoFilterIndex = 1

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

ColumnHeader Class
ColumnHeader Members

User-Task Documentation

Customizing the Appearance of Headers