ActiveReports 14 .NET Edition
GrapeCity.ActiveReports.Export.Excel Assembly / GrapeCity.SpreadBuilder.Cells Namespace / DDCell Class / BorderBottomColor Property
Example

In This Topic
    BorderBottomColor Property (DDCell)
    In This Topic
    Sets or returns the color of the bottom border.
    Syntax
    'Declaration
     
    Public Property BorderBottomColor As Color
    public Color BorderBottomColor {get; set;}

    Property Value

    System.Drawing.Color.
    Remarks
    This property has no effect if the BorderBottomStyle property is not set.
    Example
    sb.Sheets[0].Cell(0,0).Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right;
    sb.Sheets[0].Cell(0,0).BorderBottomColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).BorderDiagonalColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both;
    sb.Sheets[0].Cell(0,0).BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair;
    sb.Sheets[0].Cell(0,0).BorderLeftColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).BorderRightColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).BorderTopColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).FillColor = System.Drawing.Color.Gray;
    sb.Sheets[0].Cell(0,0).FontBold = true;
    sb.Sheets[0].Cell(0,0).FontItalic = true;
    sb.Sheets[0].Cell(0,0).FontName = "Times New Roman";
    sb.Sheets[0].Cell(0,0).FontSize = 14;
    sb.Sheets[0].Cell(0,0).FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single;
    sb.Sheets[0].Cell(0,0).ForeColor = System.Drawing.Color.Blue;
    sb.Sheets[0].Cell(0,0).Hyperlink = "www.GrapeCity.com";
    sb.Sheets[0].Cell(0,0).NumberFormat = "[$¥-0]#,##0.00";
    sb.Sheets[0].Cell(0,0).TextAngle = 255;
    sb.Sheets[0].Cell(0,0).VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top;
    sb.Sheets[0].Cell(0,0).WrapText = true;
    With sb.Sheets(0).Cell(0, 0)
        .Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right
        .BorderBottomColor = System.Drawing.Color.Red
        .BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .BorderDiagonalColor = System.Drawing.Color.Red
        .BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both
        .BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair
        .BorderLeftColor = System.Drawing.Color.Red
        .BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .BorderRightColor = System.Drawing.Color.Red
        .BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .BorderTopColor = System.Drawing.Color.Red
        .BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .FillColor = System.Drawing.Color.Gray
        .FontBold = True
        .FontItalic = True
        .FontName = "Times New Roman"
        .FontSize = 14
        .FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single
        .ForeColor = System.Drawing.Color.Blue
        .Hyperlink = "www.GrapeCity.com"
        .NumberFormat = "[$¥-0]#,##0.00"
        .TextAngle = 255
        .VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top
        .WrapText = True
    End With
    See Also