.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

RowCollection.UnGroup(Int32, Int32, Boolean) Method

Ungroups the grouped rows on a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll


void UnGroup(
    int first,
    int last,
    bool unhideCollapsed
Sub UnGroup(
    first As Integer,
    last As Integer,
    unhideCollapsed As Boolean


Name Type Description
first Int32

A zero-based integer representing the index of the first row to be ungrouped.

last Int32

A zero-based integer representing the index of the last row to be ungrouped.

unhideCollapsed Boolean

true, if the collapsed rows are displayed after ungrouping; otherwise, false.


To ungroup rows in a worksheet, call the RowCollection.UnGroup method of the Worksheet.Rows collection. Pass indexes of the first and last rows to be ungrouped, and a value indicating whether or not collapsed rows should be shown after ungrouping.

// Ungroup four rows (from the third row to the sixth row) and display collapsed data.
worksheet.Rows.UnGroup(2, 5, true);

// Ungroup four rows (from the ninth row to the twelfth row).
worksheet.Rows.UnGroup(8, 11, false);

// Remove the outer group of rows.
worksheet.Rows.UnGroup(1, 12, false);
See Also