The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

RowCollection.UnGroup(Int32, Int32, Boolean) Method

Ungroups the grouped rows on a worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

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

Parameters

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.

Parameters

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.

Parameters

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.

Examples

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