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

ColumnCollection.UnGroup(Int32, Int32, Boolean) Method

Ungroups the grouped columns on a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.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 column to be ungrouped.

last Int32

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

unhideCollapsed Boolean

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


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

// Ungroup four columns (from the column "C" to the column "F").
worksheet.Columns.UnGroup(2, 5, false);
See Also