Interface SpreadsheetParamIf

The parameters of SpreadsheetFactory.create. All optional.

Since

1.1.99

Hierarchy

  • SpreadsheetParamIf

Properties

columnCount: number

Columns of the sheet. Default max(longest row, 26) (A–Z).

columnWidth: number

Width of a column in px. Default 100.

data: unknown[][]

Rows × columns of inputs; formulas as "=…". Default: empty.

functions: Record<string, FormulaFunction>

Own functions of the cell formulas.

locale: string

The locale of typed and pasted values (sheetInputPipe): "1,5" is 1.5 in "de-DE". Default: the browser's locale. Formulas always use . and English function names.

rowCount: number

Rows of the sheet. Default max(data.length, 100).

rowHeight: number

Height of a row in px. Default 30.

rowNumbers: boolean

Row numbers in front (they count the rows of the sheet, also when sorted). Default true.

tableOptions: Partial<TableOptionsIf>

Merged over the options of the factory (selection, focus, the spreadsheet preset).