Gets or sets whether the rows in the group are expanded.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Expanded As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Group
Dim value As Boolean
instance.Expanded = value
value = instance.Expanded |
| C# | |
|---|
public bool Expanded {get; set;} |
Property Value
Boolean:
true if group of rows is displayed expanded;
false if group of rows is displayed collapsed
Example
This example returns whether the group is expanded.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[1];
sort[0] = new FarPoint.Web.Spread.SortInfo(0, true);
gm.Group(sort, System.Collections.Comparer.Default);
FpSpread1.ActiveSheetView.DataModel = gm;
FarPoint.Web.Spread.Model.Group dg = new FarPoint.Web.Spread.Model.Group(gm, (FarPoint.Web.Spread.Model.Group)gm.Groups[0], 0, true);
bool b = dg.Expanded;
String msg = b.ToString();
Response.Write("alert('" + msg + "')");
|
| Visual Basic | Copy Code |
|---|
Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel)
Dim sort(0) As FarPoint.Web.Spread.SortInfo
sort(0) = New FarPoint.Web.Spread.SortInfo(0, True)
gm.Group(sort)
FpSpread1.ActiveSheetView.DataModel = gm
Dim dg As New FarPoint.Web.Spread.Model.Group(gm, gm.Groups(0), 0, True)
Dim b As Boolean = dg.Expanded
Dim msg As String = b.ToString()
Response.Write("alert('" & msg & "')")
|
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
