Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ColumnHeader Class / AutoFilterIndex Property
Example


In This Topic
    AutoFilterIndex Property (ColumnHeader)
    In This Topic
    Gets or sets which column header row displays the row filter indicator when there are multiple column header rows.
    Syntax
    '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;
    
    FpSpread1.ActiveSheetView.ColumnHeader.AutoFilterIndex = 1
    
    See Also