Spread for ASP.NET 11 Product Documentation
Handling Row Expansion
Spread for ASP.NET 11 Product Documentation > Developer's Guide > Managing Data Binding > Handling Row Expansion

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.

C#
Copy Code
FpSpread1.Sheets[0].DataSource = ds;
FpSpread1.Sheets[0].SetRowExpandable(0, false); 
VB
Copy Code
FpSpread1.Sheets(0).DataSource = ds
FpSpread1.Sheets(0).SetRowExpandable(0, False) 
See Also