Spread Windows Forms 11.0 Product Documentation
ColumnFooterVerticalGridLine Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : ColumnFooterVerticalGridLine Property
Gets or sets the vertical grid line in the column footer for the sheet.
Syntax
'Declaration
 
Public Property ColumnFooterVerticalGridLine As GridLine
'Usage
 
Dim instance As SheetView
Dim value As GridLine
 
instance.ColumnFooterVerticalGridLine = value
 
value = instance.ColumnFooterVerticalGridLine
public GridLine ColumnFooterVerticalGridLine {get; set;}
Exceptions
ExceptionDescription
No value is specified (specified value is null)
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].ColumnFooterVisible = true;
fpSpread1.Sheets[0].ColumnFooterRowCount = 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].ColumnFooterHorizontalGridLine = gl; 
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterVerticalGridLine = 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).ColumnFooterVisible = True
fpSpread1.Sheets(0).ColumnFooterRowCount = 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).ColumnFooterHorizontalGridLine = gl 
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
fpSpread1.Sheets(0).ColumnFooterVerticalGridLine = 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)
See Also

Reference

SheetView Class
SheetView Members