Spread Windows Forms 8.0 Product Documentation
VerticalGridLine Property (ColumnFooter)
Example 


Gets or sets the vertical grid line in the column header.
Syntax
'Declaration
 
Public Property VerticalGridLine As GridLine
'Usage
 
Dim instance As ColumnFooter
Dim value As GridLine
 
instance.VerticalGridLine = value
 
value = instance.VerticalGridLine
public GridLine VerticalGridLine {get; set;}
Example
This example creates a column footer.
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);  
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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

ColumnFooter Class
ColumnFooter Members

 

 


Copyright © GrapeCity, inc. All rights reserved.