The preset tableOptions.spreadsheet (TableOptionsIf.spreadsheet): which parts it switches on. Each part is true by default; false leaves it off, an object configures it. Options the table options set themselves win.
tableOptions.spreadsheet
true
false
const tableOptions: TableOptionsIf = { ...new TableOptions(), spreadsheet: { cellFormulas: { columns: ["total"] } } }; Copy
const tableOptions: TableOptionsIf = { ...new TableOptions(), spreadsheet: { cellFormulas: { columns: ["total"] } } };
1.1.99
Cell formulas (=B2*C2).
=B2*C2
Copy, cut and paste.
Excel-style editing – the preset sets defaultEditable: true (columns without own editable are editable).
defaultEditable: true
editable
The fill handle.
Undo and redo.
The preset
tableOptions.spreadsheet(TableOptionsIf.spreadsheet): which parts it switches on. Each part istrueby default;falseleaves it off, an object configures it. Options the table options set themselves win.Example
Since
1.1.99