With a hierarchical display of data, as discussed in Displaying Data as a Hierarchy, users can be allowed to expand the rows that have more data or they can be prevented from expanding those rows. Use the GetRowExpandable and SetRowExpandable properties of the sheet (or in the sheet models) to control the ability of users to expand the rows.

You can customize the icons for expanding and collapsing hierarchies. For more information, refer to Customizing the Graphical Interface.

Using a Shortcut

Set the SetRowExpandable method.

Example

This example code sets the SetRowExpandable method.

FpSpread1.Sheets[0].DataSource = ds;
FpSpread1.Sheets[0].SetRowExpandable(0, false); 

FpSpread1.Sheets(0).DataSource = ds
FpSpread1.Sheets(0).SetRowExpandable(0, False)