Manuals/calci/SPREAD

SPREAD(Array,MaxRowToFill,MaxColToFill)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is any set of values.

Description

• SPREAD takes an array and spreads it on nearby spreadsheet cells.
• This prevents an array result being held in once cell.

Example

1. SPREAD([1,2,3],2,2) = 1 2 3

See Also

• SIZE
• DUPLICATE

References

• List of Main Z Functions

• Z3 home