Visual Basic (Declaration) | |
---|---|
Public Overridable Function IsRowExpanded( _ ByVal row As Integer _ ) As Boolean |
Visual Basic (Usage) | ![]() |
---|---|
Dim instance As SheetView Dim row As Integer Dim value As Boolean value = instance.IsRowExpanded(row) |
Parameters
- row
- Row index
Return Value
Boolean: true if the row is expanded; false otherwiseException | Description |
---|---|
System.ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
This example illustrates the use of this member by returning if the specified row of the child view has been expanded.
C# | ![]() |
---|---|
System.Data.DataSet ds = new System.Data.DataSet(); DataTable name; DataTable city; name = ds.Tables.Add("Customers"); name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)), new 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 DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new 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.ActiveSheet.DataSource = ds; fpSpread1.ActiveSheet.DataMember = "Customers"; fpSpread1.ActiveSheet.SetColumnWidth(2, 150); bool b; fpSpread1.ActiveSheet.ExpandRow(1, true); b = fpSpread1.ActiveSheet.IsRowExpanded(1); listBox1.Items.Add(b.ToString()); |
Visual Basic | ![]() |
---|---|
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")) Dim b As Boolean FpSpread1.ActiveSheet.DataSource = ds FpSpread1.ActiveSheet.DataMember = "Customers" FpSpread1.ActiveSheet.SetColumnWidth(2, 150) FpSpread1.ActiveSheet.ExpandRow(1, True) b = FpSpread1.ActiveSheet.IsRowExpanded(1) ListBox1.Items.Add(b.ToString()) |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
Reference
SheetView ClassSheetView Members