Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Top10FilterItem Class / DisplayAtTopOfList Property
Example


In This Topic
    DisplayAtTopOfList Property (Top10FilterItem)
    In This Topic
    Gets or sets whether the display name is added to the top of the filter drop-down list.
    Syntax
    'Declaration
     
    Public Overrides Property DisplayAtTopOfList As Boolean
    'Usage
     
    Dim instance As Top10FilterItem
    Dim value As Boolean
     
    instance.DisplayAtTopOfList = value
     
    value = instance.DisplayAtTopOfList
    public override bool DisplayAtTopOfList {get; set;}
    Example
    This example uses the DisplayAtTopOfList property.
    protected void Page_Load(object sender, EventArgs e)
            {
                if (this.IsPostBack) return;
    
                FpSpread1.Sheets[0].Cells[0, 1].Value = 30;
                FpSpread1.Sheets[0].Cells[1, 1].Value = 15;
                FpSpread1.Sheets[0].Cells[2, 1].Value = 10;
    
                FarPoint.Web.Spread.Top10FilterItem top10filter = new FarPoint.Web.Spread.Top10FilterItem(true, 5, false);
                FarPoint.Web.Spread.IRowFilter rowFilter = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView);
                FarPoint.Web.Spread.FilterColumnDefinition fd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom);
                top10filter.DisplayAtTopOfList = true;
                fd.Filters.Add(top10filter);
                rowFilter.ColumnDefinitions.Add(fd);
                FpSpread1.ActiveSheetView.RowFilter = rowFilter;
                FpSpread1.ActiveSheetView.AutoFilterColumn(1, top10filter.DisplayName);
                FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced;
                ListBox1.Items.Add(top10filter.DisplayName.ToString());
            }
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            If (IsPostBack) Then
                Return
            End If
            FpSpread1.Sheets(0).Cells(0, 1).Value = 30
            FpSpread1.Sheets(0).Cells(1, 1).Value = 15
            FpSpread1.Sheets(0).Cells(2, 1).Value = 10
            Dim top10filter As New FarPoint.Web.Spread.Top10FilterItem(True, 5, False)
            Dim rowFilter As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView)
            Dim fd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom)
            top10filter.DisplayAtTopOfList = True
            fd.Filters.Add(top10filter)
            rowFilter.ColumnDefinitions.Add(fd)
            FpSpread1.ActiveSheetView.RowFilter = rowFilter
            FpSpread1.ActiveSheetView.AutoFilterColumn(1, top10filter.DisplayName)
            FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced
            ListBox1.Items.Add(top10filter.DisplayName.ToString())
        End Sub
    See Also