Gets or sets the background for cells in this column.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Background As Background |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Column
Dim value As Background
instance.Background = value
value = instance.Background |
Property Value
The background.
Example
This example sets the background of all the cells in a column.
| 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.Column mycol;
for (int i = 0; i < FpSpread1.ActiveSheetView.ColumnCount; i++)
{
FpSpread1.ActiveSheetView.SetValue(i, 1, "Column Test");
mycol= FpSpread1.ActiveSheetView.Columns[i];
mycol.Background = bg;
mycol.Width = 140;
} |
| Visual Basic | Copy 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 mycol As FarPoint.Web.Spread.Column
Dim i As Integer = 0
Do While (i < FpSpread1.ActiveSheetView.ColumnCount)
FpSpread1.ActiveSheetView.SetValue(i, 1, "Column Test")
mycol = FpSpread1.ActiveSheetView.Columns(i)
mycol.Background = bg
mycol.Width = 140
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
