IRangeProvider.Union(IEnumerable<CellRange>) Method

Creates a complex range that is the union of multiple ranges.

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#

CellRange Union(
    IEnumerable<CellRange> enumerable
)

VB.NET

Function Union(
    enumerable As IEnumerable(Of CellRange)
) As CellRange

Parameters

Name	Type	Description
enumerable	IEnumerable<CellRange>	A list of CellRange objects.

Returns

Type	Description
CellRange	A CellRange composed of multiple ranges.

Remarks

A complex (union) range can be also created by multiple selection in a worksheet. A complex range can be used in the same manner as a simple range. The CellRange.Areas property provides access to the ranges to which a complex range is comprised.