Spread Windows Forms 17
In This Topic
    EXPAND
    In This Topic

    This function expands or pads an array to the specified row and column dimensions.

    Syntax

    EXPAND(array,rows,[columns],[pad\_with])

    Arguments

    The function provides the following arguments:

    Argument

    Description

    array

    The array to expand

    rows

    The number of rows in the expanded array. If missing, rows will not be expanded.

    columns

    [Optional]The number of columns in the expanded array. If missing, columns will not expanded.
    pad_with [Optional] The value with which to pad. The default is #N/A.

    Remarks

    Data Types

    The function returns an array,the type of each value in the array depends on the parameter.

    Examples

    expand

    Version Available

    This function is available in product version 16.0 or later.