How to expand or collapse group programmatically in WinRT SfSpreadsheet?

3 mins read

SfSpreadsheet 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 expand 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));

Sample links:

Did you find this information helpful?

Yes

Comments (0)

How to expand or collapse group programmatically in WinRT SfSpreadsheet?

Access denied