Skip to content

Vizier Spreadsheet

Oliver Kennedy edited this page Dec 31, 2023 · 4 revisions

The Vizier Spreadsheet

You can add a spreadsheet cell by selecting the spreadsheet button image:

  • Next to the title of any dataset displayed after a cell (adds a spreadsheet immediately after the cell)
  • Next to the title of any dataset in the artifact list (adds a spreadsheet at the end of the workflow)

Vizier Spreadsheet cells allow you to make edits to data frames directly as spreadsheets. Once you're done editing, click the Green Save button at the lower-right to save your edits, or the Red Back button at the lower-left to revert your edits.

Formula Support

Limited support for formulas is available. A cell update that starts with the '=' character will be interpreted as a formula (after dropping the '=' character). Formulas can refer to other columns in the same row by column name, or use SparkSQL Functions. Otherwise, formatting is similar to SparkSQL.