sequence-column-spill |
SEQUENCE |
=SEQUENCE(3) |
interaction |
|
sequence-row-spill |
SEQUENCE |
=SEQUENCE(1, 3) |
interaction |
|
sequence-2d-spill |
SEQUENCE |
=SEQUENCE(3, 2) |
interaction |
|
hstack-scalars |
HSTACK |
=HSTACK(1, 2, 3) |
value |
|
vstack-scalars |
VSTACK |
=VSTACK(1, 2, 3) |
value |
|
hstack-arrays |
HSTACK |
=HSTACK(A1:A2, B1:B2) |
value |
|
vstack-arrays |
VSTACK |
=VSTACK(A1:B1, A2:B2) |
value |
|
array-literal-row |
lit:array |
={1, 2, 3} |
value |
2 |
array-literal-column |
lit:array |
={1; 2; 3} |
value |
|
sort-spill |
SORT |
=SORT({3;1;2}) |
interaction |
|
unique-spill |
UNIQUE |
=UNIQUE({1;2;1;3;2}) |
interaction |
|
filter-spill |
FILTER |
=FILTER({1;2;3;4;5}, {1;0;1;0;1}) |
interaction |
|
map-spill |
MAP |
=MAP({1;2;3}, LAMBDA(x, x*2)) |
interaction |
|
single-cell-result-no-spill |
SUM |
=SUM(1, 2, 3) |
interaction |
|
index-from-spilled-source |
INDEX |
=INDEX(A1:A3, 2) |
value |
|