The grouping feature affects the visual display and is not intended to work with some other features of Spread that also work with the display of the spreadsheet. When grouping happens, the data model is changed and a new model (the GroupDataModel) is used. Many features are not affected by grouping at all, but some features, listed below, are not intended to operate with grouping. In general, if the feature involves the appearance or interactivity of the sheet or column, check the list to see if it is affected by grouping.
Some formatting features can work with grouping, but need to be applied after grouping occurs. If you need to format cells (colors, locked, etc.), you must apply the formatting after grouping.
Features Influenced by Grouping
These features do not interoperate with grouping in Spread.
- Filtering: Grouping and filtering do not work together. If you want to use grouping, you should not use filtering and you should clear the filter under the Grouping event.
- Conditional Formatting: Grouping and conditional formatting do not work together. Conditional formatting requires the default data model. Thus, these features do not work together.
- Formulas: Grouping and formulas do not work together. Formulas requires the default data model. Thus, these features do not work with grouping.
- Sorting: Grouping and sorting do not work together. Grouping is a type of sorting. When grouping is on, clicking on column headers will cause grouping, not sorting. Thus, these features do not work together.
- Count: After grouping rows, you should not change the column count and row count. The GroupDataModel does not support changing the column or row count. To add or remove columns or rows, you need to call the original data model methods. You can access the original data model using TargetModel property of the GroupDataModel class.
These features work with grouping in Spread.
- Grouping and hidden columns work together.
- Printing and exporting work with grouping.