Interface StandaloneWorkbookProps

interface StandaloneWorkbookProps {
    autoFocus?: boolean;
    autoFocusDisabled?: boolean;
    commands?: CommandMap;
    contextMenuProps?: WorkbookContextMenuProps;
    createWorkbookOptions?: IWorkbookModelOptions;
    errorPanel?: ComponentType<ErrorPanelProps>;
    forceLightImages?: boolean;
    formulaBarProps?: FormulaBarProps;
    gridTheme?: Theme;
    importExportDisabled?: boolean;
    loadingPanelProps?: LoadingPanelProps;
    logo?: ReactNode;
    model?: IWorkbookModel | Promise<IWorkbookModel>;
    notifier?: Notifier;
    onCommandsChange?: ((commands) => void);
    onElementLoad?: ((event) => void);
    onError?: ((error) => void);
    onModelChange?: ((model) => void);
    onRepeatCommandChange?: ((command) => void);
    onTitleChange?: ((title) => void);
    renderContextMenu?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>);
    renderFormulaBar?: ((props, ref) => ReactElement<any, string | JSXElementConstructor<any>>);
    renderLoadingPanel?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>);
    renderSheet?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>);
    renderStatusBar?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>);
    renderTabs?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>);
    renderToolbar?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>);
    sheetProps?: SheetProps;
    showFormulaBar?: boolean;
    showHorizontalScrollbar?: boolean;
    showStatusBar?: boolean;
    showTabs?: boolean;
    showVerticalScrollbar?: boolean;
    statusBarProps?: StatusBarProps;
    sx?: SxProps<Theme>;
    tabsProps?: WorkbookStripProps;
    themeOptions?: ThemeOptions;
    title?: string;
    titleProps?: WorkbookTitleProps;
    toolbarProps?: WorkbookToolbarsProps;
    undoManager?: UndoManager;
}

Hierarchy

Properties

autoFocus? autoFocusDisabled? commands? contextMenuProps? createWorkbookOptions? errorPanel? forceLightImages? formulaBarProps? gridTheme? importExportDisabled? loadingPanelProps? logo? model? notifier? onCommandsChange? onElementLoad? onError? onModelChange? onRepeatCommandChange? onTitleChange? renderContextMenu? renderFormulaBar? renderLoadingPanel? renderSheet? renderStatusBar? renderTabs? renderToolbar? sheetProps? showFormulaBar? showHorizontalScrollbar? showStatusBar? showTabs? showVerticalScrollbar? statusBarProps? sx? tabsProps? themeOptions? title? titleProps? toolbarProps? undoManager?

Properties

Optional autoFocus

autoFocus?: boolean

Will autofocus to the sheet.

Default Value

false

Optional autoFocusDisabled

autoFocusDisabled?: boolean

Autofocus on load. If loading multiple workbooks or using an a secondary component this should be set to false.

Remarks

Default Value

false

Optional commands

commands?: CommandMap

Additional commands provided by application

Optional contextMenuProps

contextMenuProps?: WorkbookContextMenuProps

Allow for customizations on context menu

Optional createWorkbookOptions

createWorkbookOptions?: IWorkbookModelOptions

Options to use when a new WorkbookModel is created.

Remarks

This is ignored if the model is provided externally. The default behavior is to use the options from the current workbook if provided.

Optional errorPanel

errorPanel?: ComponentType<ErrorPanelProps>

Allow for a custom error panel to be used for errors

Default Value

ErrorPanel

Optional forceLightImages

forceLightImages?: boolean

If dark theme then the images will invert unless true.

Default Value

false

Optional formulaBarProps

formulaBarProps?: FormulaBarProps

Allow for customizations on FormulaBar

Optional gridTheme

gridTheme?: Theme

Allow you to specify a specific material ui theme for the grid

Remarks

This is useful if you want to decorate the application with a single theme (such as dark mode). But render the main grid using a different theme (for example light mode).

Default Value

the current Theme

Optional importExportDisabled

importExportDisabled?: boolean

Optional loadingPanelProps

loadingPanelProps?: LoadingPanelProps

Allow for customizations on loading panel

Optional logo

logo?: ReactNode

Optional model

model?: IWorkbookModel | Promise<IWorkbookModel>

Optional notifier

notifier?: Notifier

Configure the notifier to use for alerts

Optional onCommandsChange

onCommandsChange?: ((commands) => void)

Notify that there is a new map of commands

Type declaration

    • (commands): void

    • Parameters

      Returns void

Optional onElementLoad

onElementLoad?: ((event) => void)

Callback for when the workbook is loaded. Useful for hiding/showing loading panels

Type declaration

Optional onError

onError?: ((error) => void)

Called if the workbook model is a promise that fails to load

Type declaration

    • (error): void

    • Parameters

      • error: any

      Returns void

Optional onModelChange

onModelChange?: ((model) => void)

Called if the model changes

Type declaration

Returns

Optional onRepeatCommandChange

onRepeatCommandChange?: ((command) => void)

Notify that there is a new repeatable command

Type declaration

    • (command): void

    • Parameters

      Returns void

Optional onTitleChange

onTitleChange?: ((title) => void)

Call if the title changes

Type declaration

    • (title): void

    • Parameters

      • title: string

      Returns void

Returns

Optional renderContextMenu

renderContextMenu?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>)

Render custom context menu

Type declaration

    • (props): ReactElement<any, string | JSXElementConstructor<any>>

    • Parameters

      Returns ReactElement<any, string | JSXElementConstructor<any>>

Returns

Optional renderFormulaBar

renderFormulaBar?: ((props, ref) => ReactElement<any, string | JSXElementConstructor<any>>)

Render FormulaBar

Type declaration

    • (props, ref): ReactElement<any, string | JSXElementConstructor<any>>

    • Parameters

      Returns ReactElement<any, string | JSXElementConstructor<any>>

Returns

Optional renderLoadingPanel

renderLoadingPanel?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>)

Render custom loading panel

Type declaration

    • (props): ReactElement<any, string | JSXElementConstructor<any>>

    • Parameters

      Returns ReactElement<any, string | JSXElementConstructor<any>>

Returns

Optional renderSheet

renderSheet?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>)

Render Sheet

Type declaration

    • (props): ReactElement<any, string | JSXElementConstructor<any>>

    • Parameters

      Returns ReactElement<any, string | JSXElementConstructor<any>>

Returns

Optional renderStatusBar

renderStatusBar?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>)

Pass in a custom toolbar

Type declaration

    • (props): ReactElement<any, string | JSXElementConstructor<any>>

    • Parameters

      Returns ReactElement<any, string | JSXElementConstructor<any>>

Returns

Optional renderTabs

renderTabs?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>)

Render custom tabs

Type declaration

    • (props): ReactElement<any, string | JSXElementConstructor<any>>

    • Parameters

      Returns ReactElement<any, string | JSXElementConstructor<any>>

Returns

Optional renderToolbar

renderToolbar?: ((props) => ReactElement<any, string | JSXElementConstructor<any>>)

Pass in a custom toolbar

Type declaration

    • (props): ReactElement<any, string | JSXElementConstructor<any>>

    • Parameters

      • props: WorkbookToolbarsProps

      Returns ReactElement<any, string | JSXElementConstructor<any>>

Returns

Optional sheetProps

sheetProps?: SheetProps

Allow for customizations on loading panel

Optional showFormulaBar

showFormulaBar?: boolean

Default Value

'workbook model but can be overridden'

Optional showHorizontalScrollbar

showHorizontalScrollbar?: boolean

Show the horizontal scrollbar

Optional showStatusBar

showStatusBar?: boolean

Shows the statusbar

Default Value

'workbook model but can be overridden'

Optional showTabs

showTabs?: boolean

This doesn't influence # of tabs just the visibility of the widget.

Default Value

'workbook model but can be overridden'

Optional showVerticalScrollbar

showVerticalScrollbar?: boolean

Show the vertical scrollbar

Optional statusBarProps

statusBarProps?: StatusBarProps

Customizations for the status bar

Optional sx

sx?: SxProps<Theme>

MUI SX props

See

https://mui.com/system/getting-started/the-sx-prop/

Optional tabsProps

tabsProps?: WorkbookStripProps

Allow for customizations on tabs

Optional themeOptions

themeOptions?: ThemeOptions

Standalone workbook will inherit the theme unless this is explicitly set.

Remarks

If this is set then there are two additional options that can be provided onForceModeChange(mode: ThemeMode); onForceLightGridChange(force: boolean); onForceLightImagesChange(force: boolean);

Optional title

title?: string

Title to display.

Remarks

If title is null then it is hidden but if it is '' then it is shown with placeholder

Default Value

none

Optional titleProps

titleProps?: WorkbookTitleProps

Additional WorkbookTitle properties

Remarks

If onTitleChange or title is provided then the prop versions are ignored

Optional toolbarProps

toolbarProps?: WorkbookToolbarsProps

Props for the toolbar.

Optional undoManager

undoManager?: UndoManager

Allow for a custom undo manager

Default Value

a new undo manager for each standaloneWorkbook

Settings

Member Visibility

Theme

On This Page

autoFocusautoFocusDisabledcommandscontextMenuPropscreateWorkbookOptionserrorPanelforceLightImagesformulaBarPropsgridThemeimportExportDisabledloadingPanelPropslogomodelnotifieronCommandsChangeonElementLoadonErroronModelChangeonRepeatCommandChangeonTitleChangerenderContextMenurenderFormulaBarrenderLoadingPanelrenderSheetrenderStatusBarrenderTabsrenderToolbarsheetPropsshowFormulaBarshowHorizontalScrollbarshowStatusBarshowTabsshowVerticalScrollbarstatusBarPropssxtabsPropsthemeOptionstitletitlePropstoolbarPropsundoManager