Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / FilterBarHeaderStyleName Property
Example


In This Topic
    FilterBarHeaderStyleName Property
    In This Topic
    Gets or sets the name of the style for the filter bar header.
    Syntax
    'Declaration
     
    Public Property FilterBarHeaderStyleName As String
    'Usage
     
    Dim instance As SheetView
    Dim value As String
     
    instance.FilterBarHeaderStyleName = value
     
    value = instance.FilterBarHeaderStyleName
    public string FilterBarHeaderStyleName {get; set;}
    Exceptions
    ExceptionDescription
    Specified NamedStyle object could not be found in the collection
    Example
    This example gets the FilterBarHeaderStyleName property.
    fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
    FarPoint.Win.Spread.NamedStyle backstyle = new FarPoint.Win.Spread.NamedStyle("BlueBack", "FilterBarEnhanced");
    backstyle.BackColor = Color.Blue;
    fpSpread1.NamedStyles.Add(backstyle);
    
    FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
    sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
    sheetView.FilterBarHeaderVerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Red, Color.Green, Color.Pink, 10);
    sheetView.FilterBarHeaderHorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Lowered, Color.Orange, Color.Green, Color.Pink, 10);
    sheetView.FilterBarHeaderStyle = backstyle;
    listBox1.Items.Add(sheetView.FilterBarHeaderStyleName.ToString());
    FpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off
    Dim backstyle As New FarPoint.Win.Spread.NamedStyle("BlueBack", "FilterBarEnhanced")
    backstyle.BackColor = Color.Blue
    FpSpread1.NamedStyles.Add(backstyle)
    
    Dim sheetview As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
    sheetview.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
    sheetview.FilterBarHeaderVerticalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Red, Color.Green, Color.Pink, 10)
    sheetview.FilterBarHeaderHorizontalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Lowered, Color.Orange, Color.Green, Color.Pink, 10)
    sheetview.FilterBarHeaderStyle = backstyle
    ListBox1.Items.Add(sheetView.FilterBarHeaderStyleName.ToString())
    See Also