Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Customizing the Sheet Appearance / Customizing the Individual Sheet Appearance / Setting a Background Image to a Cell
In This Topic
    Setting a Background Image to a Cell
    In This Topic

    You can customize the background of a cell by adding a graphic image.

    Cell with Background Image

    For more information on image cell types, refer to Setting an Image Cell.

    For more information on setting an image for all the cells in a sheet (as part of the default style) refer to Setting a Background Image for a Sheet.

    Example

    The following example adds an image to a text cell.

    C#
    Copy Code
    private void Form1_Load(object sender, System.EventArgs e)
    {
    // Create an instance of a text cell.
    FarPoint.Win.Spread.CellType.TextCellType t = new FarPoint.Win.Spread.CellType.TextCellType();
    // Load an image file and set it to BackgroundImage property.
    FarPoint.Win.Picture p = new FarPoint.Win.Picture(Image.FromFile("D:\\images\\lionstatue.jpg"), FarPoint.Win.RenderStyle.Stretch);
    t.BackgroundImage = p;
    // Apply the text cell.
    fpSpread1.ActiveSheet.Cells[1, 1].CellType = t;
    // Set the size of the cell so the image is displayed
    fpSpread1.ActiveSheet.Rows[1].Height = 50;
    fpSpread1.ActiveSheet.Columns[1].Width = 150;
    }
    
    VB
    Copy Code
    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
       ' Create an instance of a text cell.
       Dim t As New FarPoint.Win.Spread.CellType.TextCellType
       ' Load an image file and set it to BackgroundImage property.
       Dim p As New FarPoint.Win.Picture(Image.FromFile("D:\\images\\lionstatue.jpg"), FarPoint.Win.RenderStyle.Stretch)
       t.BackgroundImage = p
       ' Apply the text cell.
       fpSpread1.ActiveSheet.Cells(1, 1).CellType = t
       ' Set the size of the cell so the image is displayed
       fpSpread1.ActiveSheet.Rows(1).Height = 50
       fpSpread1.ActiveSheet.Columns(1).Width = 150
    End Sub
    

    See Also