Formualizer Docs
ReferenceFunctionsLookup Functions

SEQUENCE

SEQUENCE: Generates a sequential numeric array with configurable size, start, and step.

Summary

SEQUENCE fills values row-by-row and returns a dynamic spill.

Remarks

  • Defaults: columns=1, start=1, step=1.
  • rows and columns must be positive; otherwise returns #VALUE!.
  • Values are emitted as integers when integral, otherwise as floating-point numbers.
  • Result spills to the requested dimensions.

Examples

Simple vertical sequence
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[1],[2],[3],[4],[5]]
2x3 sequence with custom start and step
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[10,15,20],[25,30,35]]

FAQ

What input values are invalid for SEQUENCE?

rows and columns must be positive numbers; zero or negative sizes return #VALUE!.

Does SEQUENCE fill by rows or by columns first?

SEQUENCE fills row-by-row across columns, then continues on the next row using the same step increment.

Runtime metadata

Category

Lookup

Signature

SEQUENCE(arg1: Number, arg2?: Number, arg3?: Number, arg4?…: Number)

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2optionaldefault

Number · Scalar · coercion NumberLenientText

arg3optionaldefault

Number · Scalar · coercion NumberLenientText

arg4optionaldefault

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/lookup/dynamic.rs

ROWS

Returns the number of rows in a reference or array.

SORT

Sorts an array by a selected row or column and returns a spilled result.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat input values are invalid for SEQUENCE?Does SEQUENCE fill by rows or by columns first?Runtime metadata