Spread for ASP.NET 7.0 Product Documentation
Background Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Row Class : Background Property


Glossary Item Box

Gets or sets the background for cells in this row.

Syntax

Visual Basic (Declaration) 
Public Property Background As Background
Visual Basic (Usage)Copy Code
Dim instance As Row
Dim value As Background
 
instance.Background = value
 
value = instance.Background
C# 
public Background Background {get; set;}

Property Value

Background

Example

This example sets the background of all the cells in a row.
C#Copy Code
FarPoint.Web.Spread.Background bg = new FarPoint.Web.Spread.Background();
bg.SelectedBackgroundImageUrl = "picture/Winter.jpg";
bg.BackgroundImageUrl = "picture/Image.bmp";
bg.Enable = true;
bg.BackgroundAttachment = "fixed";// inherit, scroll.
bg.BackgroundPosition = "50% 50%";
bg.BackgroundRepeat = "repeat-x";

FpSpread1.ActiveSheetView.ColumnCount = 10;
FpSpread1.ActiveSheetView.PageSize = 20;
FpSpread1.ActiveSheetView.RowCount = 20;
FarPoint.Web.Spread.Row myrow;
int i;
for (i = 0; i < FpSpread1.ActiveSheetView.RowCount; i++)
{
    FpSpread1.ActiveSheetView.SetValue(i, 1, "Row Test");
    myrow = FpSpread1.ActiveSheetView.Rows[i];
    myrow.Background=bg;    
    myrow.Height = 70;
} 
Visual BasicCopy Code
Dim bg As FarPoint.Web.Spread.Background = New FarPoint.Web.Spread.Background
bg.SelectedBackgroundImageUrl = "picture/Winter.jpg"
bg.BackgroundImageUrl = "picture/Image.bmp"
bg.Enable = true
bg.BackgroundAttachment = "fixed"  ' inherit, scroll.
bg.BackgroundPosition = "50% 50%"
bg.BackgroundRepeat = "repeat-x"

FpSpread1.ActiveSheetView.ColumnCount = 10
FpSpread1.ActiveSheetView.PageSize = 20
FpSpread1.ActiveSheetView.RowCount = 20
Dim myrow As FarPoint.Web.Spread.Row
Dim i As Integer
i = 0
Do While (i < FpSpread1.ActiveSheetView.RowCount)
    FpSpread1.ActiveSheetView.SetValue(i, 1, "Row Test")
    myrow = FpSpread1.ActiveSheetView.Rows(i)
    myrow.Background = bg
    myrow.Height = 70
    i = (i + 1)
Loop

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.