Apply Grouping

Spread.Services Documentation
Apply Grouping
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Customize User Interaction > Apply Grouping

You can group rows or columns of data to organize information and create custom views in a spreadsheet.

Each group in Spread.Services is distinguished with a group header row with collapse and expand icons next to it that can be used for displaying or hiding information as and when required. You can set the Show Detail property of the IRange Interface to boolean true to expand a group to display rows and columns that have been hidden and false to collapse the expanded rows or columns.

Applying grouping in a spreadsheet involves the following tasks:

- Create Row or Column Group
- Remove a Group
- Set Summary Row

| Note : When grouping is applied, rows of data are automatically sorted in ascending order against the grouped columns.

Copyright © GrapeCity, inc. All rights reserved.