PowerTools SPREAD for ASP.NET 8.0J
SheetCornerColumnAxisModel プロパティ

シートコーナーの列情報を取得または設定します。
構文
'Declaration
 
Public Property SheetCornerColumnAxisModel As ISheetAxisModel
public ISheetAxisModel SheetCornerColumnAxisModel {get; set;}
次のサンプルコードは、シートコーナーのモデルを設定します。
FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.StyleInfo info = new FarPoint.Web.Spread.StyleInfo();
info.Border = new FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Teal, 2);
sv.SheetCorner.ColumnCount = 3;
sv.SheetCorner.RowCount = 3;
sv.SheetCornerSpanModel.Add(0, 0, 2, 2);
sv.SheetCornerStyleModel.SetDirectInfo(0, 0, info);
sv.SheetCornerRowAxisModel.SetSize(0, 100);
sv.SheetCornerColumnAxisModel.SetSize(0, 100);
FpSpread1.Sheets.Add(sv);
ListBox1.Items.Add(sv.SheetCornerDataModel.ColumnCount.ToString());
ListBox1.Items.Add(sv.SheetCornerDataModel.RowCount.ToString());
Dim sv As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
Dim info As New FarPoint.Web.Spread.StyleInfo()
info.Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, Color.Teal, 2)
sv.SheetCorner.ColumnCount = 3
sv.SheetCorner.RowCount = 3
sv.SheetCornerSpanModel.Add(0, 0, 2, 2)
sv.SheetCornerStyleModel.SetDirectInfo(0, 0, info)
sv.SheetCornerRowAxisModel.SetSize(0, 100)
sv.SheetCornerColumnAxisModel.SetSize(0, 100)
FpSpread1.Sheets.Add(sv)
ListBox1.Items.Add(sv.SheetCornerDataModel.ColumnCount.ToString())
ListBox1.Items.Add(sv.SheetCornerDataModel.RowCount.ToString())
参照

SheetView クラス
SheetView メンバ

 

 


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