Comment on page
Array formulas
Formulas can return values that spans multiple cells
Spreadsheet can display formulas that return an array of values, which spans across multiple cells. This is useful if you want to display dynamic tabular data in the spreadsheet.
Below is a sample Array formula that fetches covid data
=IMPORTDATA("https://api.covidtracking.com/v1/us/daily.csv")
With the power of Structured references, you can convert this data to table, and start filtering/sorting on this data.
Array formula to structured data
If an array formula tries to overwrite a non-empty cell, a
REF error is thrown.Returning a 2-D array from a custom formula function will mark a cell as an array function cell.
const MY_FUNCTION = (parser: FormulaParser, arg: FunctionArgument) => {
return [
[
"foo",
"bar"
]
]
}