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

In This Topic
    BorderLeftStyle Property (DDCell)
    In This Topic
    Sets or returns the line style for the left portion of the cell's border.
    Syntax
    'Declaration
     
    Public Property BorderLeftStyle As BorderLineStyle
    public BorderLineStyle BorderLeftStyle {get; set;}

    Property Value

    BorderLineStyle enumeration.
    Remarks
    This property must be set for the BorderLeftColor property to have an effect.
    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