Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetMergedCellList.ExpandArea(Integer,Integer) Method

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

#Declaration

Delphi
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.

See Also