Spread.NET 17 Formula Reference
Formula Overview / Array Formulas
In This Topic
    Array Formulas
    In This Topic

    You can use array formulas with the control.

    An array formula can perform multiple calculations on one or more items in an array. Array formulas can return multiple results or a single result.

    To create an array formula, select the cells you wish to put the formula in, type the formula, and then use Ctrl + Shift + Enter. This puts braces around the formula and places an instance of the formula in each cell of the selected range.

    In order to remove or change an array formula, you must select the original formula range first.