Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / WRAPCOLS
In This Topic
    WRAPCOLS
    In This Topic

    This function wraps the provided row or column of values by columns after a specified number of elements to form a new array.

    Syntax

    =WRAPCOLS(vector, wrap_count, [pad_with])

    Arguments

    The function has the following arguments:

    Argument

    Description

    vector

    		 The vector or reference to wrap.
    wrap_count The maximum number of values for each column.
    pad_with

    [Optional] The value with which to pad. The default is #N/A.

    Remarks

    The elements of the vector are placed into a 2-dimensional array by column. Each column has wrap_count elements. The column is padded with pad_with if there are insufficient elements to fill it. If wrap_count is greater or equal to the number of elements in vector, then the vector is simply returned as the result of the function.

    Data Types

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

    Examples

    Version Available

    This function is available in product version 16.0 or later.

    Note: The WRAPCOLS function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.