Spreadsheet allows you to expand or collapse the groups in a worksheet.
Groups can be collapsed by using CollapseGroup method of IRange and then hide the columns of SpreadsheetGrid like below.
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.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|