ExpandRow(Int32,Boolean) Method

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

Syntax

Visual Basic
C#

'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
)

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.

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

Visual Basic

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SpreadView Class
SpreadView Members