Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Sub ExpandRow( _ ByVal row As Integer, _ ByVal expand As Boolean _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SpreadView Dim row As Integer Dim expand As Boolean instance.ExpandRow(row, expand) | |
Parameters
- row
- Index of parent row to expand or collapse
- expand
- True to expand and show the child sheet; false to collapse and hide the child sheet
Remarks
The Expand event fires when calling the spread view ExpandRow method.
Example
This example expands the first row in the hierarchical display.
| C# | Copy Code |
|---|---|
Dim sv As New FarPoint.Win.Spread.SpreadView(fpSpread1) sv = fpSpread1.GetRootWorkbook() sv.ExpandRow(0, True) | |
| Visual Basic | Copy Code |
|---|---|
FarPoint.Win.Spread.SpreadView sv = new FarPoint.Win.Spread.SpreadView(fpSpread1); sv = fpSpread1.GetRootWorkbook(); sv.ExpandRow(0, true); | |
Requirements
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