FilterBarHorizontalGridLine Property

Gets or sets the horizontal grid line for the filter bar.

Syntax

Visual Basic
C#

'Declaration
 
Public Property FilterBarHorizontalGridLine As GridLine

'Usage
 
Dim instance As SheetView
Dim value As GridLine
 
instance.FilterBarHorizontalGridLine = value
 
value = instance.FilterBarHorizontalGridLine

public GridLine FilterBarHorizontalGridLine {get; set;}

Exceptions

Exception	Description
System.ArgumentNullException	No value is specified (specified value is null)

Example

This example sets the FilterBarHorizontalGridLine property.

FarPoint.Win.Spread.GridLine HGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Red);
FarPoint.Win.Spread.GridLine VGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Chartreuse);
fpSpread1.Sheets[0].FilterBarVerticalGridLine = VGridLine;
fpSpread1.Sheets[0].FilterBarHorizontalGridLine = HGridLine;
fpSpread1.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;

VB.NET

Dim HGridLine As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Red)
Dim VGridLine As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Chartreuse)
FpSpread1.Sheets(0).FilterBarVerticalGridLine = VGridLine
FpSpread1.Sheets(0).FilterBarHorizontalGridLine = HGridLine
FpSpread1.Sheets(0).AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members