Gets or sets the horizontal grid line in the column header.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property HorizontalGridLine As GridLine |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As ColumnFooter
Dim value As GridLine
instance.HorizontalGridLine = value
value = instance.HorizontalGridLine |
| C# | |
|---|
public GridLine HorizontalGridLine {get; set;} |
Example
This example creates a column footer.
| C# | Copy Code |
|---|
fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the footer.
fpSpread1.Sheets[0].ColumnFooter.Visible = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.ColumnHeaderRenderer();
FarPoint.Win.Spread.GridLine gl = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Crimson, Color.Goldenrod, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooter.HorizontalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooter.VerticalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooterSheetCornerHorizontalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterSheetCornerVerticalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood); |
| Visual Basic | Copy Code |
|---|
FpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 15
FpSpread1.Sheets(0).ColumnFooter.Visible = True
FpSpread1.Sheets(0).ColumnFooter.RowCount = 2
FpSpread1.Sheets(0).ColumnFooter.DefaultStyle.Renderer = New FarPoint.Win.Spread.CellType.ColumnHeaderRenderer()
Dim gl As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Crimson, Color.Goldenrod, Color.BurlyWood)
FpSpread1.Sheets(0).ColumnFooter.HorizontalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
FpSpread1.Sheets(0).ColumnFooter.VerticalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood)
FpSpread1.Sheets(0).ColumnFooterSheetCornerHorizontalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
FpSpread1.Sheets(0).ColumnFooterSheetCornerVerticalGridLine = gl
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood) |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
