Sheets can display relational data, such as from a relational database, in hierarchical
The user can expand or collapse the levels of the hierarchy by clicking on the expand
and collapse hierarchy icons (plus and minus signs).
To set up hierarchical data display, you first create a data set to hold the relational
data, then define the relations between the data, and finally, set the FarPoint
Spread component to display the data as you want. You can customize the cell type,
the colors, the headers, and other aspects of the appearance of the view. You can
also bind to a hierarchical collection.