Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Column Class / Border Property
Example


In This Topic
    Border Property (Column)
    In This Topic
    Gets or sets the default border for cells in this column.
    Syntax
    'Declaration
     
    Public Property Border As Border
    'Usage
     
    Dim instance As Column
    Dim value As Border
     
    instance.Border = value
     
    value = instance.Border
    public Border Border {get; set;}

    Property Value

    Border object that contains the border for the cells in this column
    Remarks
    The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets a border.
    Example
    This example creates a spreadsheet with 10 columns and 20 rows. A Column object and a Border object are then created. The Column object is assigned to the second column of the spreadsheet. The Border objects design is assigned to the Border property of the Column object, such that all the cells in the second column have a red, grooved border around them.
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.PageSize=20;
    FpSpread1.ActiveSheetView.RowCount=20;
    FarPoint.Web.Spread.Column mycol;
    FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Groove,Color.Red,3);
    mycol=FpSpread1.ActiveSheetView.Columns[1];
    mycol.Border=bord;
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.PageSize=20
    FpSpread1.ActiveSheetView.RowCount=20
    Dim mycol As FarPoint.Web.Spread.Column
    Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Groove,Color.Red,3)
    mycol=FpSpread1.ActiveSheetView.Columns(1)
    mycol.Border=bord
    See Also