ColumnFooterSheetCornerHorizontalGridLine Property

In This Topic

Gets or sets the horizontal grid line for the column footer sheet corner.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ColumnFooterSheetCornerHorizontalGridLine As GridLine

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

public GridLine ColumnFooterSheetCornerHorizontalGridLine {get; set;}

Exceptions

Exception	Description
System.ArgumentNullException	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].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

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)

Reference

SheetView Class
SheetView Members

Product Support Forum | Print this page