Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Border Class / BorderStyleTop Property
Example


In This Topic
    BorderStyleTop Property
    In This Topic
    Gets or sets the style for the top border.
    Syntax
    'Declaration
     
    Public Property BorderStyleTop As BorderStyle
    'Usage
     
    Dim instance As Border
    Dim value As BorderStyle
     
    instance.BorderStyleTop = value
     
    value = instance.BorderStyleTop
    public BorderStyle BorderStyleTop {get; set;}

    Property Value

    BorderStyle setting for the top border
    Remarks

    For more information on these border styles, see the BorderStyle enumeration in the Microsoft .NET Framework Reference.

    If you want to set the border style for all sides of the object to the same style, use the BorderStyle property.

    To check if other border style properties have been set, use the IsDefined method.

    Example
    This example sets a border.
    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);
    
    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)
    
    See Also