|
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.
C# //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.
C# // 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:
|
2X faster development
The ultimate WPF UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
