How to expand or collapse the group programmatically in WinForms Spreadsheet (SfSpreadsheet)?

3 mins read

Expand or collapse the group

The Spreadsheet allows you to expand or collapse the groups in a worksheet.

Collapse group:

Groups can be collapsed by using CollapseGroup method of IRange and then hide the columns of SpreadsheetGrid like below.

//Collapse columns
Spreadsheet.ActiveSheet.Range["C3:F6"].CollapseGroup(ExcelGroupBy.ByColumns);
Spreadsheet.ActiveGrid.ColumnWidths.SetHidden(3, 6, true);

Expand group:

Groups can be expanded by ExpandGroup method of IRange and then unhide the columns of SpreadsheetGrid like below. And also invalidate cells to refresh the view.

// Expand columns
Spreadsheet.ActiveSheet.Range["C3:F6"].ExpandGroup(ExcelGroupBy.ByColumns);
Spreadsheet.ActiveGrid.ColumnWidths.SetHidden(3, 6, false);
Spreadsheet.ActiveGrid.InvalidateCell(GridRangeInfo.Cols(3,7));

Samples:

Did you find this information helpful?

Yes