Skip to main content

TdxSpreadSheetAreaList Class

A list of rectangles corresponding to individual cells or cell ranges.

Declaration

TdxSpreadSheetAreaList = class(
    TdxRectList
)

Remarks

Cell range lists are used to specify which data cells are affected by a specific conditional formatting rule.

The TdxSpreadSheetAreaList class extends its ancestor with the following methods that allow you to:

  • Populate the cell range list (Assign and AssignFromString);

  • Copy the current cell range list (Clone);

  • Check if any cell range within the list contains a specific point (Contains);

  • Check if any cell range within the list intersects a specific area (Intersects);

  • Compare two cell range lists (Equals);

  • Create references to all cell ranges within the list (ToString).

The Areas property of the TdxSpreadSheetCustomConditionalFormattingRule class references a TdxSpreadSheetAreaList object.

Inheritance

See Also