Javascript Spreadsheet Ribbon

A ribbon is a command bar that organizes a Spreadsheet’s features into a series of tabs at the top of the control.

Ribbon Customization

You can perform the Ribbon customization in the following two ways.

1) Initial Load

2) Methods

Initial Load

The Ribbon customization can be done at Initial load by using ribbonSettings API. In ribbonSettings applicationTab options is available for ribbon customization.

Application Tab

To set application tab in Spreadsheet, applicationTab property is used. The following options are available in applicationTab settings.

  • type is used to set application tab type in Spreadsheet.
  • menuSettings is used to indicate menu settings for application tab in Spreadsheet. The following options are available in menuSettings.

    1) isAppend is used to enable or disable isAppend property in ribbon settings.

    2) dataSource is used to specify the data source to append in application tab.

Methods

You can also customize the ribbon by using the following methods.

Feature Method Name Description
Add BackStage Item

addBackStageItem

To add a new item in the backstage.
Add Contextual Tabs

addContextualTabs

To add the contextual tabs in the ribbon.
Add Menu Item

addMenuItem

To dynamically add the menu item in the file menu.
Add Tab

addTab

To dynamically add the tab in the ribbon.
Add Tab Group

addTabGroup

To dynamically add the tab group in the ribbon.
Auto Sum

autoSum

To insert the few type (SUM, MAX, MIN, AVG, COUNT) of formulas in the selected range of cells in the Spreadsheet.
Change Dimension

changeDimension

To change the dimensions for chart/picture.
Disable Ribbon Items

disableRibbonItems

To disable ribbon items in the Spreadsheet.
Enable Ribbon Items

enableRibbonItems

To enable ribbon items in the Spreadsheet.
Hide Menu

hideMenu

To hide the file menu in the ribbon tab.
Remove BackStage Item

removeBackStageItem

To remove the item from the backstage in the Spreadsheet.
Remove Menu Item

removeMenuItem

To remove the menu item from file menu in Spreadsheet.
Remove Tab

removeTab

To remove the tab from ribbon in the spreadsheet.
Remove Tab Group

removeTabGroup

To remove the tab group from ribbon in the Spreadsheet.
Show Menu

showMenu

To show the file menu in the ribbon tab.
Update Menu Item

updateMenuItem

To update the menu item in the file menu.
Update Ribbon Icons

updateRibbonIcons

To update the ribbon icons in the Spreadsheet.