Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Cell Class / BackColor Property

In This Topic
    BackColor Property (Cell)
    In This Topic
    Gets or sets the background color for a cell.
    Public Property BackColor As Color
    Dim instance As Cell
    Dim value As Color
    instance.BackColor = value
    value = instance.BackColor
    public Color BackColor {get; set;}

    Property Value

    Color object containing the background color of the cell

    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 the background color.

    When cells are locked with the Lock and Protect properties, the value of the SheetView.LockBackColor property overrides the value of this property.

    If you use this property to retrieve the background color for a range of cells that do not have the same background color, the background color of the active cell is returned.

    This property does not change the background color of the drop-down list portion of a combo box cell. The background color of the drop-down list portion of a combo box cell is always white.

    If you are working with button cells, use the CellType.ButtonCellType.ButtonColor property to specify the color of the face of the buttons. If you prefer, you can use alternating background colors for the rows in the spreadsheet by using the AlternatingRow.BackColor property for each alternating row.

    Specify the text color for the cell by setting the ForeColor property.

    This example generates random background and foreground colors and assigns them to the cells in the sheet.
    FarPoint.Win.Spread.Cell acell;
    int i, j;
    int iColorR = 0;
    int iColorG = 0;
    int iColorB = 0;
    Random rand = new Random();
    fpSpread1.ActiveSheet.ColumnCount = 20;
    fpSpread1.ActiveSheet.RowCount = 20;
    acell = fpSpread1.ActiveSheet.Cells[0, 0];
    for (i = 0; i <= fpSpread1.ActiveSheet.RowCount - 1; i++)
         for (j = 0; j<= fpSpread1.ActiveSheet.ColumnCount - 1; j++)
              acell = fpSpread1.ActiveSheet.Cells[i, j];
              acell.BackColor = Color.FromArgb(iColorR, iColorG, iColorB);
              acell.ForeColor = Color.FromArgb(iColorB, iColorR, iColorG);
              iColorR = rand.Next(0, 255);
              iColorG = rand.Next(0, 255);
              iColorB = rand.Next(0,255);
    Dim acell As FarPoint.Win.Spread.Cell
    Dim i, j, c As Integer
    Dim iColorR, iColorG, iColorB As Integer
    fpSpread1.ActiveSheet.ColumnCount = 20
    fpSpread1.ActiveSheet.RowCount = 20
    For i = 0 To fpSpread1.ActiveSheet.RowCount - 1
         For j = 0 To fpSpread1.ActiveSheet.ColumnCount - 1
              acell = fpSpread1.ActiveSheet.Cells(i, j)
              iColorR = Int(255 * Rnd()) + 1
              iColorG = Int(255 * Rnd()) + 1
              iColorB = Int(255 * Rnd()) + 1
              acell.BackColor = Color.FromArgb(iColorR, iColorG, iColorB)
              acell.ForeColor = Color.FromArgb(iColorB, iColorR, iColorG)
         Next j
    Next i
    See Also