TdxSpreadSheetCustomFormula.ArrayFormulaArea Property

Returns the area occupied by the array formula result.

Declaration

property ArrayFormulaArea: TRect read;

Property Value

Type
TRect

Remarks

Use this property to identify both the dimensions and position of a cell range that stores the array formula calculation result.

The ArrayFormulaArea.Size property returns (-1, -1) if the formula expression returns a single value instead of an array.

You can call the IsArrayFormula function to identify if the calculated formula expression result is an array.