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


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

    Property Value

    Color object containing the color of text in the selected cells
    Remarks

    To set the background color for selected cells, set the SelectionBackColor property.

    This property is not used for client-side scripting.

    The selection text color and selection border 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