Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ColumnFooterVerticalGridLine Property
Example


In This Topic
    ColumnFooterVerticalGridLine Property
    In This Topic
    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