Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView.LayoutModeType Enumeration
Example Example


In This Topic
    SheetView.LayoutModeType Enumeration
    In This Topic
    Specifies the type of layout mode.
    Syntax
    'Declaration
     
    Public Enum SheetView.LayoutModeType 
       Inherits System.Enum
    'Usage
     
    Dim instance As SheetView.LayoutModeType
    public enum SheetView.LayoutModeType : System.Enum 
    Members
    MemberDescription
    CellLayoutModeUses the cell layout mode.
    RowTemplateLayoutModeUses the row template layout mode.
    Example
    This example uses the SheetView.LayoutModeType enumeration.
    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.RowTemplateLayoutMode
    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
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Web.Spread.SheetView.LayoutModeType

    See Also