Gets or sets the style for the bottom border.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property BorderStyleBottom As BorderStyle |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Border
Dim value As BorderStyle
instance.BorderStyleBottom = value
value = instance.BorderStyleBottom |
Property Value
BorderStyle setting for the bottom border
Remarks
Example
This example creates a spreadsheet with 7 columns and 50 rows. It sets the first column of cells to be currency cells with a double border on the bottom and left side of the cells and a groove border on the right and top of the cells. The bottom and left side have a 5-pixel thick blue border.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.CurrencyCellType currcell = new FarPoint.Web.Spread.CurrencyCellType();
FarPoint.Web.Spread.Border aborder = new FarPoint.Web.Spread.Border();
FarPoint.Web.Spread.StyleInfo currstyle = new FarPoint.Web.Spread.StyleInfo();
FpSpread1.Sheets[0].ColumnCount = 7;
FpSpread1.Sheets[0].RowCount = 50;
currcell.Size = 20;
aborder.BorderColorBottom = Color.Blue;
aborder.BorderColorLeft = Color.Blue;
aborder.BorderSize = 5;
aborder.BorderStyleBottom = BorderStyle.Double;
aborder.BorderStyleLeft = BorderStyle.Double;
aborder.BorderStyleRight = BorderStyle.Groove;
aborder.BorderStyleTop = BorderStyle.Groove;
currstyle.CellType = currcell;
currstyle.Border = aborder;
FpSpread1.Sheets[0].SetStyleInfo(-1, 0, currstyle);
|
| Visual Basic | Copy Code |
|---|
Dim currcell As New FarPoint.Web.Spread.CurrencyCellType()
Dim aborder As New FarPoint.Web.Spread.Border()
Dim currstyle As New FarPoint.Web.Spread.StyleInfo()
FpSpread1.Sheets(0).ColumnCount = 7
FpSpread1.Sheets(0).RowCount = 50
currcell.Size = 20
aborder.BorderColorBottom = Color.Blue
aborder.BorderColorLeft = Color.Blue
aborder.BorderSize = 5
aborder.BorderStyleBottom = BorderStyle.Double
aborder.BorderStyleLeft = BorderStyle.Double
aborder.BorderStyleRight = BorderStyle.Groove
aborder.BorderStyleTop = BorderStyle.Groove
currstyle.CellType = currcell
currstyle.Border = aborder
FpSpread1.Sheets(0).SetStyleInfo(-1, 0, currstyle)
|
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
