ColumnCollection.UnGroup(String, String, Boolean) Method

Ungroups the grouped columns on a worksheet.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

void UnGroup(
    string firstColumnHeading,
    string lastColumnHeading,
    bool unhideCollapsed
)

VB.NET

Sub UnGroup(
    firstColumnHeading As String,
    lastColumnHeading As String,
    unhideCollapsed As Boolean
)

Parameters

Name	Type	Description
firstColumnHeading	String	The heading of the first column to ungroup.
lastColumnHeading	String	The heading of the last column to ungroup.
unhideCollapsed	Boolean	true, to show the collapsed columns after the ungroup operation; otherwise, false.

Remarks

The method’s firstColumnHeading and lastColumnHeading parameters require column headings in the A1 reference style.

C#

// Ungroup columns from the column "D" to the column "G".
worksheet.Columns.UnGroup("D", "G", false);

VB.NET

' Ungroup columns from the column "D" to the column "G".
worksheet.Columns.UnGroup("D", "G", False)

See how to group data in a worksheet.