Visual Basic (Declaration) | |
---|---|
Public Property AutoFilterIndex As Integer |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As ColumnHeader Dim value As Integer instance.AutoFilterIndex = value value = instance.AutoFilterIndex |
C# | |
---|---|
public int AutoFilterIndex {get; set;} |
Property Value
Integer number representing the zero-based row indexIf 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.
C# | Copy Code |
---|---|
FpSpread1.ActiveSheetView.ColumnHeader.AutoFilterIndex = 1; |
Visual Basic | Copy Code |
---|---|
FpSpread1.ActiveSheetView.ColumnHeader.AutoFilterIndex = 1 |
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
Reference
ColumnHeader ClassColumnHeader Members