Sets or returns the line style for the bottom portion of the cell's border.

Syntax

Visual Basic (Declaration)
Public Property BorderBottomStyle As BorderLineStyle

Visual Basic (Usage)	Copy Code
`Dim instance As DDCell Dim value As BorderLineStyle instance.BorderBottomStyle = value value = instance.BorderBottomStyle`

C#
public BorderLineStyle BorderBottomStyle {get; set;}

Return Value

BorderLineStyle enumeration.

Example

C# Copy Code

C#	Copy Code
sb.Sheets[0].Cell(0,0).Alignment = DataDynamics.SpreadBuilder.Style.HorzAlignments.Right; sb.Sheets[0].Cell(0,0).BorderBottomColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderBottomStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderDiagonalColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderDiagonalEnum = DataDynamics.SpreadBuilder.Style.BorderDiagonalStyles.Both; sb.Sheets[0].Cell(0,0).BorderDiagonalStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Hair; sb.Sheets[0].Cell(0,0).BorderLeftColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderLeftStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderRightColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderRightStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderTopColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderTopStyle = DataDynamics.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 = DataDynamics.SpreadBuilder.Style.FontUnderlineStyles.Single; sb.Sheets[0].Cell(0,0).ForeColor = System.Drawing.Color.Blue; sb.Sheets[0].Cell(0,0).Hyperlink = "www.datadynamics.com"; sb.Sheets[0].Cell(0,0).NumberFormat = "[$¥; sb.Sheets[0].Cell(0,0).TextAngle = 255; sb.Sheets[0].Cell(0,0).VertAlignment = DataDynamics.SpreadBuilder.Style.VertAlignments.Top; sb.Sheets[0].Cell(0,0).WrapText = true;

sb.Sheets[0].Cell(0,0).Alignment =
DataDynamics.SpreadBuilder.Style.HorzAlignments.Right;

sb.Sheets[0].Cell(0,0).BorderBottomColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderBottomStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double;

sb.Sheets[0].Cell(0,0).BorderDiagonalColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderDiagonalEnum =
DataDynamics.SpreadBuilder.Style.BorderDiagonalStyles.Both;

sb.Sheets[0].Cell(0,0).BorderDiagonalStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Hair;

sb.Sheets[0].Cell(0,0).BorderLeftColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderLeftStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double;

sb.Sheets[0].Cell(0,0).BorderRightColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderRightStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double;

sb.Sheets[0].Cell(0,0).BorderTopColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderTopStyle =
DataDynamics.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 =
DataDynamics.SpreadBuilder.Style.FontUnderlineStyles.Single;

sb.Sheets[0].Cell(0,0).ForeColor =
System.Drawing.Color.Blue;

sb.Sheets[0].Cell(0,0).Hyperlink =
"www.datadynamics.com";

sb.Sheets[0].Cell(0,0).NumberFormat =
"[$¥;

sb.Sheets[0].Cell(0,0).TextAngle = 255;

sb.Sheets[0].Cell(0,0).VertAlignment =
DataDynamics.SpreadBuilder.Style.VertAlignments.Top;

sb.Sheets[0].Cell(0,0).WrapText =
true;

Remarks

This property must be set for the BorderBottomColor property to have an effect.

ActiveReports.XlsExport	Request technical support
BorderBottomStyle Property
See Also Example

Syntax

Return Value

Example

Remarks

See Also

Reference