Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SelectionBorder Property
Example


In This Topic
    SelectionBorder Property
    In This Topic
    Gets or sets the settings for the selection border.
    Syntax
    'Declaration
     
    Public Property SelectionBorder As Border
    'Usage
     
    Dim instance As SheetView
    Dim value As Border
     
    instance.SelectionBorder = value
     
    value = instance.SelectionBorder
    public Border SelectionBorder {get; set;}

    Property Value

    Border object with border for selected cells
    Remarks

    This property is not used for client-side scripting.

    The settings for the selection border are contained in the Border class, which includes properties to set the color, size, and style for the border's sides.

    The selection border and selection text color are displayed only in down-level browsers.

    Example
    This example uses the SheetView object to change the appearance of a selected cell or cells, and selects a range of cells and returns if a cell in row 0 has been selected.
    FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
    FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3);
    bool bl;
    sv.SelectionModel.SetSelection(0,0,3,3);
    bl=sv.SelectionModel.IsAnyCellInRowSelected(0);
    sv.SelectionBackColor=Color.Yellow;
    sv.SelectionForeColor=Color.Red;
    sv.SelectionBorder=bord;
    sv.SetValue(0,0,"Test");
    ListBox1.Items.Add(Convert.ToString(bl));
    Dim sv As FarPoint.Web.Spread.SheetView
    Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3)
    Dim bl As Boolean
    sv=FpSpread1.ActiveSheetView
    sv.SelectionModel.SetSelection(0,0,3,3)
    bl=sv.SelectionModel.IsAnyCellInRowSelected(0)
    sv.SelectionBackColor=Color.Yellow
    sv.SelectionForeColor=Color.Red
    sv.SelectionBorder=bord
    sv.SetValue(0,0,"Test")
    ListBox1.Items.Add(bl)
    See Also