Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / Expandable Property

In This Topic
    Expandable Property
    In This Topic
    Gets or sets whether the rows are expandable.
    Public Overridable Property Expandable As Boolean
    Dim instance As SheetView
    Dim value As Boolean
    instance.Expandable = value
    value = instance.Expandable
    public virtual bool Expandable {get; set;}
    This example uses the Expandable property.
    System.Data.DataSet ds = new System.Data.DataSet();
    System.Data.DataTable name;
    System.Data.DataTable city;
    name = ds.Tables.Add("Customers");
    name.Columns.AddRange(new System.Data.DataColumn[] { new System.Data.DataColumn("LastName", typeof(string)), new System.Data.DataColumn("FirstName", typeof(string)), new System.Data.DataColumn("ID", typeof(Int32)) });
    name.Rows.Add(new object[] { "Fielding", "William", 0 });
    name.Rows.Add(new object[] { "Williams", "Arthur", 1 });
    name.Rows.Add(new object[] { "Zuchini", "Theodore", 2 });
    city = ds.Tables.Add("City/State");
    city.Columns.AddRange(new System.Data.DataColumn[] { new System.Data.DataColumn("City", typeof(string)), new System.Data.DataColumn("Owner", typeof(Int32)), new System.Data.DataColumn("State", typeof(string)) });
    city.Rows.Add(new object[] { "Atlanta", 0, "Georgia" });
    city.Rows.Add(new object[] { "Boston", 1, "Mass." });
    city.Rows.Add(new object[] { "Tampa", 2, "Fla." });
    ds.Relations.Add("City/State", name.Columns["ID"], city.Columns["Owner"]);
    //FpSpread1.Sheets[0].Expandable = false;
    FpSpread1.DataSource = ds;
    Dim ds As New System.Data.DataSet
    Dim name As DataTable
    Dim city As DataTable
    name = ds.Tables.Add("Customers")
    name.Columns.AddRange(New DataColumn() {New DataColumn("LastName", Type.GetType("System.String")), New DataColumn("FirstName",
    Type.GetType("System.String")), New DataColumn("ID", Type.GetType("System.Int32"))})
    name.Rows.Add(New Object() {"Fielding", "William", 0})
    name.Rows.Add(New Object() {"Williams", "Arthur", 1})
    name.Rows.Add(New Object() {"Zuchini", "Theodore", 2})
    city = ds.Tables.Add("City/State")
    city.Columns.AddRange(New DataColumn() {New DataColumn("City", Type.GetType("System.String")), New DataColumn("Owner", Type.GetType("System.Int32")),
    New DataColumn("State", Type.GetType("System.String"))})
    city.Rows.Add(New Object() {"Atlanta", 0, "Georgia"})
    city.Rows.Add(New Object() {"Boston", 1, "Mass."})
    city.Rows.Add(New Object() {"Tampa", 2, "Fla."})
    ds.Relations.Add("City/State", name.Columns("ID"), city.Columns("Owner"))
    'FpSpread1.Sheets(0).Expandable = False
    FpSpread1.ActiveSheetView.DataSource = ds
    See Also