Spread for ASP.NET 7.0 Product Documentation
DisplayAtTopOfList Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Top10FilterItem Class : DisplayAtTopOfList Property


Glossary Item Box

Gets or sets whether the display name is added to the top of the filter drop-down list.

Syntax

Visual Basic (Declaration) 
Public Overrides Property DisplayAtTopOfList As Boolean
Visual Basic (Usage)Copy Code
Dim instance As Top10FilterItem
Dim value As Boolean
 
instance.DisplayAtTopOfList = value
 
value = instance.DisplayAtTopOfList
C# 
public override bool DisplayAtTopOfList {get; set;}

Example

This example sets the DisplayAtTopOfList property.
C#Copy Code
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());
        }
VB.NETCopy Code
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

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.