Features

  • 3 minutes to read

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

BootstrapSpreadsheet_Overview

NOTE

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...