GrapeCity.Documents.Excel.IOutlineColumn.SetCollapsed

SetCollapsed Method

SetCollapsed(int, bool)

Sets whether the specified row is collapsed.

Declaration

void SetCollapsed(int row, bool collapsed)

Sub SetCollapsed(row As Integer, collapsed As Boolean)

Parameters

Type	Name	Description
int	row	The index of the row whose collapsed state is to be set.
bool	collapsed	true to display the specified row in a collapsed state; otherwise, false.

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{"Name"}, {"Node 1"}, {"Node 1.1"}};
worksheet.Range["A3"].IndentLevel = 1;
worksheet.Outline.SummaryRow = SummaryRow.Above;
IOutlineColumn outlineColumn = worksheet.OutlineColumn;
outlineColumn.ColumnIndex = 0;
outlineColumn.ShowIndicator = true;
outlineColumn.Refresh();
outlineColumn.SetCollapsed(1, true);