officefileapi-devexpress-dot-spreadsheet-dot-columncollection-dot-ungroup-x28-system-dot-int32-system-dot-int32-system-dot-boolean-x29.md
Ungroups the grouped columns on a worksheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
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);
' Ungroup four columns (from the column "C" to the column "F").
worksheet.Columns.UnGroup(2, 5, False)
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.
// Ungroup four columns (from the column "C" to the column "F").
worksheet.Columns.UnGroup(2, 5, false);
#endregion #UngroupColumns
// Ungroup four columns (from the column "C" to the column "F").
worksheet.Columns.UnGroup(2, 5, false);
#endregion #UngroupColumns
// Ungroup columns "C" through "F".
worksheet.Columns.UnGroup(2, 5, false);
#endregion #UngroupColumns
' Ungroup four columns (from the column "C" to the column "F").
worksheet.Columns.UnGroup(2, 5, False)
' #End Region ' #UngroupColumns
' Ungroup four columns (from the column "C" to the column "F").
worksheet.Columns.UnGroup(2, 5, False)
' #End Region ' #UngroupColumns
' Ungroup columns "C" through "F".
worksheet.Columns.UnGroup(2, 5, False)
' #End Region ' #UngroupColumns
See Also