- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
WRAPCOLS
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. |
Data Types
The function returns an array, the type of each value in the array depends on the parameter.
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.
Examples
