PowerTools SPREAD for ASP.NET 8.0J
Background プロパティ (Column)

この列のセルの背景を取得または設定します。
構文
'Declaration
 
Public Property Background As Background
public Background Background {get; set;}

プロパティ値

背景。
次のサンプルコードは、ある列のすべてのセルの背景を設定します。
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;    
} 
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
参照

Column クラス
Column メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.