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</br> Method Name</br> Description</br>
Add BackStage Item</br>

addBackStageItem

</br>
To add a new item in the backstage.</br>
Add Contextual Tabs</br>

addContextualTabs

</br>
To add the contextual tabs in the ribbon.</br>
Add Menu Item </br>

addMenuItem

</br>
To dynamically add the menu item in the file menu.</br>
Add Tab </br>

addTab

</br>
To dynamically add the tab in the ribbon.</br>
Add Tab Group </br>

addTabGroup

</br>
To dynamically add the tab group in the ribbon.</br>
Auto Sum </br>

autoSum

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

changeDimension

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

disableRibbonItems

</br>
To disable ribbon items in the Spreadsheet.</br>
Enable Ribbon Items</br>

enableRibbonItems

</br>
To enable ribbon items in the Spreadsheet.</br>
Hide Menu</br>

hideMenu

</br>
To hide the file menu in the ribbon tab.</br>
Remove BackStage Item</br>

removeBackStageItem

</br>
To remove the item from the backstage in the Spreadsheet.</br>
Remove Menu Item</br>

removeMenuItem

</br>
To remove the menu item from file menu in Spreadsheet.</br>
Remove Tab</br>

removeTab

</br>
To remove the tab from ribbon in the spreadsheet.</br>
Remove Tab Group</br>

removeTabGroup

</br>
To remove the tab group from ribbon in the Spreadsheet.</br>
Show Menu</br>

showMenu

</br>
To show the file menu in the ribbon tab.</br>
Update Menu Item</br>

updateMenuItem

</br>
To update the menu item in the file menu.</br>
Update Ribbon Icons</br>

updateRibbonIcons

</br>
To update the ribbon icons in the Spreadsheet.</br>