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

TdxSpreadSheetCustomFormula.IsArrayFormula Property

Specifies if the formula expression’s calculation result is an array.

#Declaration

Delphi
property IsArrayFormula: Boolean read; write;

#Property Value

Type
Boolean

#Remarks

You can use this property to:

  • Identify whether the formula expression returns an array as a calculation result;

  • Switch the formula expression between the array and single value result modes.

For more information on working with array formulas, refer to the Array Formulas and How to Work with Array Formulas. The Built-in Operators and Functions topic lists all functions available for use in formula expressions.

Note

Not all built-in functions can return either a single value or array. All array formula functions are divided into three groups:

  • Functions that return only a single value;

  • Functions that return only an array;

  • Functions that can return either a single value or array, depending on the IsArrayFormula property value.

See Also