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

In This Topic
    Alignment Property (DDCell)
    In This Topic
    Sets or returns the horizontal alignment value for the cell.
    Syntax
    'Declaration
     
    Public Property Alignment As HorzAlignments
    public HorzAlignments Alignment {get; set;}

    Property Value

    HorzAlignments Enumeration. The default value is General.
    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