Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

UI Customization

  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    xv
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
 
v
Show/hide grid lines
Show/hide headings

The DevExpress ASP.NET Spreadsheet (ASPxSpreadsheet) 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 the Spreadsheet's main UI elements available for customization through the API provided at different levels - for the whole control or for individual worksheets.

At the control level, the following customization options are available:

  • The mode of the ribbon-based UI (use the RibbonMode property)
    The Spreadsheet is designed to fully integrate the DevExpress ASP.NET Ribbon control (ASPxRibbon). 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 ASPxSpreadsheet's RibbonTabs collection.
    • One Line Ribbon – 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 ASPxRibbon control, specified by the AssociatedRibbonID property. Ribbon tabs can be customized at the ASPxRibbon control level with the Tabs property. The ASPxSpreadsheet'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.
  • The Formula Bar visibility (use the ShowFormulaBar property)
  • The Tab Control visibility (use the ShowSheetTabs property)

At the level of a worksheet, you can programmatically toggle the visibility of the following worksheet elements:

Give the demo a try and see how the Spreadsheet looks and behaves in different UI modes.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxSpreadsheetDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxSpreadsheetDemos