MESCIUS SPREAD for ASP.NET 10.0J
RowSpan プロパティ (LayoutCell)

レイアウトセルによって結合されるレイアウト行の数を取得または設定します。
構文
'Declaration
 
Public Property RowSpan As Integer
public int RowSpan {get; set;}

プロパティ値

行数を表す Integer
次のサンプルコードは、テンプレートを作成します。
protected void Page_Load(object sender, System.EventArgs e)
{
    if (this.IsPostBack) return;
    FpSpread1.ActiveSheetView.LayoutMode = FarPoint.Web.Spread.SheetView.LayoutModeType.RowTemplateLayoutMode;
    FarPoint.Web.Spread.WorksheetTemplate template1 = FpSpread1.Sheets[0].WorksheetTemplate;
    template1.ColumnCount = 3;
    template1.ColumnHeaderTemplate.RowCount = 2;
    template1.RowTemplate.RowCount = 2;
    template1.LayoutColumns[1].Width = 250;
    //Set row template's layout 
    template1.RowTemplate.LayoutCells[1, 1].ColumnSpan = 2;
    //set column header template's layout
    template1.ColumnHeaderTemplate.LayoutCells[0, 0].RowSpan = 2;
    template1.ColumnHeaderTemplate.LayoutCells[1, 1].ColumnSpan = 2;
    
    DataTable dt = new DataTable();
    dt.Columns.Add("ProductID");
    dt.Columns.Add("ProductName");
    dt.Columns.Add("Region");
    dt.Columns.Add("Date");
    dt.Columns.Add("Description");
    dt.Rows.Add(new object[] { 21, "Computer", "China", "2010/1/1", "Using newest display adapter" });
    dt.Rows.Add(new object[] { 36, "Notebook", "Vietnam", "2010/6/1", "Dell" });
    dt.Rows.Add(new object[] { 13, "Hard disk", "Taiwan", "2011/1/1", "Speed is 7200" });
    FpSpread1.Sheets[0].DataSource = dt;

    template1.LayoutCells[0, 0].DataIndex = 0;
    template1.LayoutCells[1, 0].DataIndex = 1;
    template1.LayoutCells[0, 1].DataIndex = 2;
    template1.LayoutCells[0, 2].DataIndex = 3;
    template1.LayoutCells[1, 1].DataIndex = 4;
    
    ////Or set RowTemplate's mapping using an older method
    //template1.RowTemplate.LayoutCells[0, 0].DataIndex = 0;
    //template1.RowTemplate.LayoutCells[1, 0].DataIndex = 1;
    //template1.RowTemplate.LayoutCells[0, 1].DataIndex = 2;
    //template1.RowTemplate.LayoutCells[0, 2].DataIndex = 3;
    //template1.RowTemplate.LayoutCells[1, 1].DataIndex = 4;
    ////Set ColumnHeaderTemplate's mapping using an older method
    //template1.ColumnHeaderTemplate.LayoutCells[0, 0].DataIndex = 0;
    //template1.RowTemplate.LayoutCells[1, 0].DataIndex = 1;              //this cell is span in ColumnHeader
    //template1.ColumnHeaderTemplate.LayoutCells[0, 1].DataIndex = 2;
    //template1.ColumnHeaderTemplate.LayoutCells[0, 2].DataIndex = 3;
    //template1.ColumnHeaderTemplate.LayoutCells[1, 1].DataIndex = 4;
}
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    If IsPostBack Then
        Return
    End If
    FpSpread1.ActiveSheetView.LayoutMode = FarPoint.Web.Spread.SheetView.LayoutModeType.RowTemplateLayoutMod    e
    Dim template1 As FarPoint.Web.Spread.WorksheetTemplate = FpSpread1.Sheets(0).WorksheetTemplate
    template1.ColumnCount = 3
    template1.ColumnHeaderTemplate.RowCount = 2
    template1.RowTemplate.RowCount = 2
    template1.LayoutColumns(1).Width = 250
    'Set row template's layout 
    template1.RowTemplate.LayoutCells(1, 1).ColumnSpan = 2
    'set column header template's layout
    template1.ColumnHeaderTemplate.LayoutCells(0, 0).RowSpan = 2
    template1.ColumnHeaderTemplate.LayoutCells(1, 1).ColumnSpan = 2

    Dim dt As New DataTable()
    dt.Columns.Add("ProductID")
    dt.Columns.Add("ProductName")
    dt.Columns.Add("Region")
    dt.Columns.Add("Date")
    dt.Columns.Add("Description")
    dt.Rows.Add(New Object() {21, "Computer", "China", "2010/1/1", "Using newest display adapter"})
    dt.Rows.Add(New Object() {36, "Notebook", "Vietnam", "2010/6/1", "Dell"})
    dt.Rows.Add(New Object() {13, "Hard disk", "Taiwan", "2011/1/1", "Speed is 7200"})
    FpSpread1.Sheets(0).DataSource = dt
    
    template1.LayoutCells(0, 0).DataIndex = 0
    template1.LayoutCells(1, 0).DataIndex = 1
    template1.LayoutCells(0, 1).DataIndex = 2
    template1.LayoutCells(0, 2).DataIndex = 3
    template1.LayoutCells(1, 1).DataIndex = 4
    
    'Set RowTemplate's mapping using an older method
    'template1.RowTemplate.LayoutCells(0, 0).DataIndex = 0
    'template1.RowTemplate.LayoutCells(1, 0).DataIndex = 1
    'template1.RowTemplate.LayoutCells(0, 1).DataIndex = 2
    'template1.RowTemplate.LayoutCells(0, 2).DataIndex = 3
    'template1.RowTemplate.LayoutCells(1, 1).DataIndex = 4
    'Set ColumnHeaderTemplate's mapping using an older method
    'template1.ColumnHeaderTemplate.LayoutCells(0, 0).DataIndex = 0
    'template1.RowTemplate.LayoutCells(1, 0).DataIndex = 1            'this cell is span in ColumnHeader
    'template1.ColumnHeaderTemplate.LayoutCells(0, 1).DataIndex = 2
    'template1.ColumnHeaderTemplate.LayoutCells(0, 2).DataIndex = 3
    'template1.ColumnHeaderTemplate.LayoutCells(1, 1).DataIndex = 4
End Sub
参照

LayoutCell クラス
LayoutCell メンバ

 

 


© MESCIUS inc. All rights reserved.