Skip to main content


  • 3 minutes to read

This document lists the main features of the DevExpress Bootstrap Spreadsheet control.



The Bootstrap Spreadsheet provides users with the same features as the ASP.NET Spreadsheet. The main difference between these controls is that the Bootstrap control also implements the client-side responsiveness and renders code clarity of the Bootstrap framework.

The list below links the topics describing features that are common for these two controls.

  • Supported File Formats

    Load, convert and save workbooks to popular file formats such as XLS, XLSX, XLSM, CSV and TXT.

    See demo… | Learn more…

  • Worksheets

    Create, rename, move, hide/unhide and delete worksheets in a workbook.

    Learn more…

  • Rows and Columns

    Insert, copy, hide and delete rows and columns, and adjust row height and column width.

    Learn more…

  • Frozen Panes

    Freeze panes to make specific columns and rows always visible while scrolling.

    See demo…

  • Cells and Cell Ranges Add data of different types, hyperlinks, and formulas to cells. Merge and unmerge cells, format, copy and clear cells, and manipulate cell ranges.

    Learn more…

  • Cell Formatting

    Customize the appearance of cells by specifying different format attributes (font, background, borders, number formats and alignment of cell content).

    Learn more…

  • Formula Calculation Engine

    Perform complex calculations using formulas with various functions and cell references, and create shared and array formulas.

    See demo… | Learn more…

  • Pictures

    Insert, move, change, transform and delete pictures in a worksheet.

    See demo…

  • Tables

    Format cell ranges as tables to manage and analyze related data.

  • Sorting

    Sort data in a range in ascending or descending order.

    See demo… | Learn more…

  • Filtering

    Filter data using the AutoFilter functionality that arranges large amounts of data by displaying only rows that meet filtering criteria.

    See demo… | Learn more…

  • Charting

    Use charts to display data in the most appropriate way. A variety of chart types (such as bar charts and line charts) and their subtypes (such as stacked horizontal pyramid charts and 3-D line charts) is supported.

    See demo… | Learn more…

  • Data Validation

    Excel-inspired data validation helps prevent end-users from entering incorrect values into worksheet cells.

    See demo… | Learn more…

  • Mail Merge

    Use the Mail Merge feature to easily personalize letters, and compose catalogs and master-detail reports of any complexity.

    See demo… | Learn more…

  • Full-text Search

    The built-in ribbon UI and a specific Find dialog allow end-users to easily locate data within a worksheet.

  • Support for Protected Documents

    When opening a document that contains protected elements, the ASPxSpreadsheet prevents them from being modified by end-users.

    See demo… | Learn more…

  • Printing

    The provided built-in ribbon UI allows end-users to easily customize the opened document for printing and print the entire workbook content.

    See demo… | Learn more…

  • Worksheet Print Settings

    Specify print settings: set the paper size, margins, orientation and other settings for worksheet pages.

    See demo… | Learn more…