Back to Devexpress

ColumnCollection.UnGroup(String, String, Boolean) Method

officefileapi-devexpress-dot-spreadsheet-dot-columncollection-dot-ungroup-x28-system-dot-string-system-dot-string-system-dot-boolean-x29.md

latest2.3 KB
Original Source

ColumnCollection.UnGroup(String, String, Boolean) Method

Ungroups the grouped columns on a worksheet.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void UnGroup(
    string firstColumnHeading,
    string lastColumnHeading,
    bool unhideCollapsed
)
vb
Sub UnGroup(
    firstColumnHeading As String,
    lastColumnHeading As String,
    unhideCollapsed As Boolean
)

Parameters

NameTypeDescription
firstColumnHeadingString

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.

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

See how to group data in a worksheet.

See Also

ColumnCollection Interface

ColumnCollection Members

DevExpress.Spreadsheet Namespace