( See demo: Mail Merging | See demo: Custom Data Merging | Learn moreвЂ¦) Use the Mail Merge feature to easily personalize letters, and compose catalogs and master-detail reports of any complexity. An Excel inspired data validation helps prevent end-users from entering wrong values into worksheet cells. 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. Use charts to display data in the most appropriate way. Filter data: use the AutoFilter functionality to arrange large amounts of data by displaying only rows that meet filtering criteria. Sort data in a range in ascending or descending order.

Format cell ranges as tables to manage and analyze related data. Insert, move, change, transform and delete pictures in a worksheet. ( See demo: Formulas | See demo: API - Functions in Formulas | Learn moreвЂ¦) Perform complex calculations using formulas with various functions and cell references, and create shared and array formulas. Customize the appearance of cells by specifying different format attributes (font, background, borders, number formats and alignment of cell content). Merge and unmerge cells, format, copy and clear cells, and manipulate cell ranges. Add data of different types, hyperlinks and formulas to cells. Freeze panes to make specific columns and rows always visible while scrolling. Insert, copy, hide and delete rows and columns, and adjust row height and column width. Create, rename, move, hide/unhide and delete worksheets in a workbook. You can also use an external ASPxRibbon as the ASPxSpreadsheet toolbar. A Ribbon UI is automatically added to your spreadsheet application with ASPxSpreadsheet. Load, convert and save workbooks to popular file formats such as XLS, XLSX, CSV, TXT, and others. The ASPxSpreadsheet class implements the Spreadsheet control on the server side and the ASPxClientSpreadsheet represents it on the client side.

The DevExpress ASP.NET Spreadsheet control allows users to create, load, modify, print, save and convert spreadsheet files.

Spreadsheet converter upgrade