CellData

type CellData = Omit<JSFCell, "f" | "v" | "s" | "dt"> & object;

Cell data, as passed to Workbook.editCell: the JSF Cell type, except that f, v and s are typed as below and z, zf and ft are added. null in f, v, s or z clears that field in an edit.

Type Declaration

dt?

optional dt?: DataTable | null;

What-if data table metadata. On an edit, establishes (or replaces) a data table anchored at the edited cell; null removes the data table anchored there. See Workbook.editCell.

f?

optional f?: string | null;

Formula string (never an index into the workbook’s formulas)

ft?

optional ft?: "a" | null;

Formula type: 'a' for array formula

s?

optional s?: number | Style | null;

Style index, or Style object

v?

optional v?:
  | string
  | number
  | boolean
  | FormulaError
  | null;

Cell value, which may be a FormulaError

z?

optional z?: string | null;

User-assigned number format (convenience shortcut for style.numberFormat)

zf?

optional zf?: string | null;

Formula-assigned number format (convenience shortcut for style.numberFormatFromFormula)