Spread Windows Forms 18
Spread Windows Forms 18 Product Documentation / Developer's Guide / Customizing Row or Column Interaction / Managing Grouping of Rows of User Data / Using Grouping
In This Topic
    Using Grouping
    In This Topic

    You can set up the display to allow Outlook-style grouping of rows. For large amounts of data, this is helpful to display the data in the order the user needs. The user selects columns by which to sort, then organizes and displays the data in a hierarchy with rows organized accordingly. To select a column by which to group and display that data, either double-click on the header of that column or click and drag that column into the grouping bar at the top of the page. See the figure below for an example of the terms used with grouping.

    grouping terminology

    You can expand or collapse groups by clicking the expand (+) or collapse (-) indicators.

    You can provide grouping to allow users to sort the data with multiple levels of groups by dragging additional column headers into the grouping area. An example of the process of setting up two levels of grouping is shown in the following figure.

    grouping: dragging the column header

    grouping: result of secondary group

    Before secondary grouping: dragging the column header into the grouping bar. After secondary grouping: now a second level of hierarchy is shown.

    When more than one level is chosen, the higher level is called the parent group and the lower level is called the child group. In the proceeding figure with secondary grouping, the Employee ID is the parent group and the First Name is the child group.

    See Also