All docs
V19.2
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

CellRange.Union(CellRange) Method

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

Namespace: DevExpress.Spreadsheet

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

Declaration

CellRange Union(
    CellRange other
)
Function Union(
    other As CellRange
) As CellRange
CellRange Union(
    CellRange other
)
Function Union(
    other As CellRange
) As CellRange
CellRange Union(
    CellRange other
)
Function Union(
    other As CellRange
) As CellRange

Parameters

Name Type Description
other CellRange

A CellRange object.

Parameters

Name Type Description
other CellRange

A CellRange object.

Parameters

Name Type Description
other CellRange

A CellRange object.

Returns

Type Description
CellRange

A CellRange composed of multiple ranges.

Returns

Type Description
CellRange

A CellRange composed of multiple ranges.

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.

This example demonstrates how to create a complex (union) range. There are several ways to accomplish this.

Ranges which comprise a complex range can be accessed using the CellRange.Areas property.

CellRange rangeA1D4 = worksheet["A1:D4"];
CellRange rangeD5E7 = worksheet["D5:E7"];
CellRange rangeRow11 = worksheet["11:11"];
CellRange rangeF7 = worksheet["F7"];

// Create a complex range using the Range.Union method.
CellRange complexRange1 = worksheet["A7:A9"].Union(rangeD5E7);

// Create a complex range using the IRangeProvider.Union method.
CellRange complexRange2 = worksheet.Range.Union(new CellRange[] { rangeRow11, rangeA1D4, rangeF7 });

// Fill the ranges with different colors.
complexRange1.FillColor = myColor1;
complexRange2.FillColor = myColor2;

// Use the Areas property to get access to a component of a complex range.
complexRange2.Areas[2].FillColor = Color.Beige;
See Also