TdxSpreadSheetMergedCellList.ExpandArea(Integer,Integer) Method

Expands one or more merged cell object areas by the specified rectangle.

Declaration

function ExpandArea(const AColumn: Integer; const ARow: Integer): TRect; overload;

Parameters

Name	Type
AColumn	Integer
ARow	Integer

Returns

Type
TRect

Remarks

Call this function to expand the area, occupied by a merged cell object in the current collection, by the cell range passed as the AArea parameter. The ExpandArea function actually expands the merged cell object’s area that has an intersection with the specified rectangle.

If the specified area fits into a merged cell object without any intersections, the ExpandArea function returnst that cell’s area. The function returns the area you specified if it neither fits into nor intersects with one of the existing merged cell areas.

The overloaded variant allows you to specify a cell by its column and row indexes as the AColumn and ARow parameters, respectively. You can use the “single-cell” variant of the ExpandArea function in the same manner as the CheckCell function.

Note

To create a new merged cell object within the current collection instead of expanding one of the existing cells, call the Add procedure.