ExpandRow(Int32,Boolean) Method

Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.

Syntax

'Declaration
 
Public Sub ExpandRow( _
   ByVal row As Integer, _
   ByVal expand As Boolean _
)

'Usage
 
Dim instance As SpreadView
Dim row As Integer
Dim expand As Boolean
 
instance.ExpandRow(row, expand)

public void ExpandRow( 
   int row,
   bool expand
)

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.

FarPoint.Win.Spread.SpreadView sv = new FarPoint.Win.Spread.SpreadView(fpSpread1);
sv = fpSpread1.GetRootWorkbook();
sv.ExpandRow(0, true);

Dim sv As New FarPoint.Win.Spread.SpreadView(fpSpread1)
sv = fpSpread1.GetRootWorkbook()
sv.ExpandRow(0, True)