[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Expand]Pivot Grid
   [Collapse]Product Information
     Main Features
     Deployment of ASPxSpreadsheet
    Getting Started
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [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

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

  • Ribbon UI
    A Ribbon UI is automatically added to your spreadsheet application with ASPxSpreadsheet. You can also use an external ASPxRibbon as the ASPxSpreadsheet 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... | 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: 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... | Learn more...

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

  • 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 | 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: use the AutoFilter functionality to arrange 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
    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 Merging | See demo: Custom Data Merging | 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...

  • Developer API
    The ASPxSpreadsheet control is built upon 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?​​​​​​​