RowCollection.UnGroup(Int32, Int32, Boolean) Method

Ungroups the grouped rows on a worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void UnGroup(
    int first,
    int last,
    bool unhideCollapsed
)

VB.NET

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.

Example

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.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832

GroupAndOutlineActions.vb

' 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)

GroupAndOutlineActions.cs

// 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);

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the UnGroup(Int32, Int32, Boolean) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/GroupAndOutlineActions.cs#L43

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

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/GroupAndOutlineActions.cs#L70

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

winforms-spreadsheetcontrol-api-part-2-e4832/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/GroupAndOutlineActions.cs#L70

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

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/GroupAndOutlineActions.vb#L42

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

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/GroupAndOutlineActions.vb#L64

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

winforms-spreadsheetcontrol-api-part-2-e4832/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/GroupAndOutlineActions.vb#L64

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