[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Collapse]ASP.NET MVC Extensions
  [Expand]Product Information
  [Expand]Getting Started
  [Expand]Common Concepts
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Pivot Grid
    Overview - Spreadsheet
    Main Features - Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors Extensions
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Extensions
  [Expand]Query Builder
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Main Features - Spreadsheet

This document lists the main features of the DevExpress ASP.NET MVC Spreadsheet.

  • Ribbon UI
    A Ribbon UI is automatically added to your spreadsheet application with Spreadsheet. You can also add an external Ribbon extension to use it as the Spreadsheet toolbar.
    See demo...

  • Supported File Formats
    Load, convert and save workbooks to popular file formats such as XLS, XLSX, XLSM, CSV and TXT.
    See demo...

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

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

  • Frozen Panes
    Freeze panes to make specific columns and rows always visible while scrolling.
    See demo: Freeze Panes

  • 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.
    See demo...

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

  • Formula Calculation Engine
    Perform complex calculations using formulas with various functions and cell references, and create shared and array formulas.
    See demo: Formulas | See demo: API - Functions in Formulas

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

  • Filtering
    Filter data: use the AutoFilter functionality to arrange large amounts of data by displaying only rows that meet filtering criteria.
    See demo...

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

  • Data Validation
    An Excel inspired data validation helps prevent end-users from entering wrong 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: Mail Merge | See demo: Custom Data Merge

  • 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 Spreadsheet prevents them from being modified by end-users.
    See demo...

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

  • Worksheet Print Settings
    Specify print settings: set the paper size, margins, orientation and other settings for worksheet pages.
    See demo...

  • Developer API
    The Spreadsheet extension is built on the Spreadsheet Core library, and exposes a comprehensive set of properties, methods, events and commands that enable you to build feature-rich applications.
    See demo...

Is this topic helpful?​​​​​​​