Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SelectionBackColor Property
Example


In This Topic
    SelectionBackColor Property (SheetView)
    In This Topic
    Gets or sets the background color for selected cells.
    Syntax
    'Declaration
     
    
    Public Property SelectionBackColor As Color
    'Usage
     
    
    Dim instance As SheetView
    Dim value As Color
     
    instance.SelectionBackColor = value
     
    value = instance.SelectionBackColor
    public Color SelectionBackColor {get; set;}

    Property Value

    Color object containing the color of the background of the selected cells
    Remarks

    This property is not used for client-side scripting.

    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