Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Top10FilterItem Class / DisplayName Property
Example


In This Topic
    DisplayName Property (Top10FilterItem)
    In This Topic
    Gets the display name of the filter.
    Syntax
    'Declaration
     
    Public Overrides ReadOnly Property DisplayName As String
    'Usage
     
    Dim instance As Top10FilterItem
    Dim value As String
     
    value = instance.DisplayName
    public override string DisplayName {get;}
    Example
    This example gets the display name.
    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.Win.Spread.Top10FilterItem top10filter = new FarPoint.Win.Spread.Top10FilterItem(true, 5, false);
    top10filter.DisplayAtTopOfList = true;
    FarPoint.Win.Spread.IRowFilter rowFilter = new FarPoint.Win.Spread.HideRowFilter(fpSpread1.ActiveSheet);
    FarPoint.Win.Spread.FilterColumnDefinition fd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Custom);
    fd.Filters.Add(top10filter);
    rowFilter.ColumnDefinitions.Add(fd);
    fpSpread1.ActiveSheet.RowFilter = rowFilter;
    fpSpread1.ActiveSheet.AutoFilterColumn(1, top10filter.DisplayName, 0);
    fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;
    listBox1.Items.Add(top10filter.DisplayName.ToString());
    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.Win.Spread.Top10FilterItem(True, 5, False)
    top10filter.DisplayAtTopOfList = True
    Dim rowFilter As New FarPoint.Win.Spread.HideRowFilter(fpSpread1.ActiveSheet)
    Dim fd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Custom)
    fd.Filters.Add(top10filter)
    rowFilter.ColumnDefinitions.Add(fd)
    fpSpread1.ActiveSheet.RowFilter = rowFilter
    fpSpread1.ActiveSheet.AutoFilterColumn(1, top10filter.DisplayName, 0)
    fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu
    ListBox1.Items.Add(top10filter.DisplayName.ToString())
    See Also