Spread ASP.NET 6.0 Product Documentation
Background Property
See Also  Example Send Feedback
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.