EmbeddedSpreadsheetOptions interface

options for creating spreadsheet

Members

add_tab
optional
boolean
allow add tab
alternate_document
optional
string
load this document if the storage document isn't found (fallback)
auto_size
optional
boolean
fill container
chart_menu
optional
boolean
chart menu in the toolbar
container
optional
string | HTMLElement
containing HTML element
delete_tab
optional
boolean
show delete tab
dnd
optional
boolean
allow drag-and-drop files
expand
optional
boolean
expandable grid
expand_formula_button
optional
boolean
expand formula bar
export
optional
boolean
export to xlsx, now optional
file_menu
optional
boolean
file options in the toolbar
font_scale
optional
boolean
font size in the toolbar
formula_bar
optional
boolean
show formula bar
freeze_columns
optional
number
freeze columns
freeze_rows
optional
number
freeze rows
global_name
optional
string
set a reference in global (self)
headers
optional
boolean
row/column headers
headless
optional
boolean
new option, better support for headless operations (default false)
hyperlinks
optional
string | false
target window for hyperlinks (default _blank); set false to disable hyperlinks altogether
imaginary_value
optional
string
for rendering the imaginary number. this is intended to support switching to a different character for rendering, or adding a leading space/half-space/hair-space.
in_cell_editor
optional
boolean
support in-cell editor
markdown
optional
boolean
support MD formatting for text
max_file_size
optional
number
max size for image, in bytes
network_document
optional
string
fetch network document (URI)
persist_scale
optional
boolean | string
save/load scale. this can optionally have a string key to disambiguate
popout
optional
boolean
popout icon
prompt_save
optional
boolean
prompt "you have unsaved changes"
recalculate
optional
boolean
recalculate on load
resizable
optional
boolean
add resizable wrapper
scale
optional
number
initial scale
scale_control
optional
boolean
show scale buttons
scroll
optional
string | ICellAddress
scroll to cell on load
scrollbars
optional
boolean
show scrollbars
sheet
optional
string
sheet to show on load, overrides anything in the model
storage_key
optional
string
key in localStorage for persisting document
tab_bar
optional
boolean | "auto"
show tab bar (multi sheet)
tint_theme_colors
optional
boolean
show tinted colors in toolbar color dropdowns
toll_initial_load
optional
boolean
don't load immediately (?)
toolbar
optional
boolean | "show" | "narrow" | "show-narrow"
toolbar display option
toolbar_recalculate_button
optional
boolean
recalculate button in the toolbar
undo
optional
boolean
support undo

Referenced by