External Ribbon

The Bootstrap Spreadsheet provides a UI experience similar to Microsoft Excel Online. It allows you to create intuitive and easy-to-use spreadsheet apps in the shortest possible time.

This demo illustrates how you can customize the Spreadsheet's built-in Ribbon. Based upon the RibbonMode property setting, the Spreadsheet can use either a built-in ribbon, a built-in one-line toolbar, an external ribbon control, or no ribbon. The RibbonMode property values include:

  • Ribbon – The Spreadsheet uses a built-in ribbon; ribbon tabs can be customized using the Spreadsheet's RibbonTabs collection.
  • One Line Ribbon – Default. The Spreadsheet displays a built-in ribbon used in one-line mode optimized for touch devices; one-line mode related settings can be defined for ribbon groups and ribbon galleries with their OneLineModeSettings properties.
  • ExternalRibbon – The Spreadsheet uses an external Bootstrap Ribbon control, specified by the AssociatedRibbonID property. Ribbon tabs can be customized at the Ribbon control level with the Tabs property. The Spreadsheet's CreateDefaultRibbonTabs method can be used to automatically populate the external ribbon with the default ribbon tabs.
  • None – The Spreadsheet does not incorporate or use the ribbon UI.
  • Auto – The Spreadsheet automatically displays a proper built-in ribbon depending upon the client browser type; a standard ribbon is used under desktop browsers and a one-line ribbon is used under the browsers of touch devices.

In this demo, the external Bootstrap Ribbon is used.

<dx:BootstrapRibbon ID="RibbonExternal" runat="server" ShowFileTab="false">
    <CssClasses Control="mb-2" />
<dx:BootstrapSpreadsheet runat="server" ActiveTabIndex="0" Height="500px" ShowConfirmOnLosingChanges="False"
    RibbonMode="ExternalRibbon" AssociatedRibbonID="RibbonExternal">
Screen Size
Color Themes
Demo QR Code