ActiveReports 9
BorderDiagonalStyle Property (DDCell)
Example 

Sets or returns the line style for the diagonal portion of the cell's border.
Syntax
'Declaration
 
Public Property BorderDiagonalStyle As BorderLineStyle
public BorderLineStyle BorderDiagonalStyle {get; set;}

Property Value

BorderLineStyle enumeration.
Remarks
This property, as well as the BorderDiagonalEnum property, must be set for the BorderDiagonalColor 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
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

DDCell Class
DDCell Members

 

 


Copyright © 2014 GrapeCity, inc. All rights reserved

Support Forum