Protection & Encryption
Use document protection and password encryption to prevent unauthorized access.
Protection & Encryption
The DevExpress WPF Spreadsheet control enables you to use password encryption to prevent unauthorized users from opening or modifying your workbooks. You can also restrict changes to workbooks, worksheets, and specific ranges. In a protected workbook, users are not allowed to add, delete or rename worksheets.
Data Validation
Reduce data entry errors and visually inform users of invalid input.
Data Validation
The Spreadsheet Control includes data validation support. With it, you can control the manner in which data is entered. An error message is displayed if a value violates restrictions you've specified. You can use predefined validation rules or implement them manually using Data Validation API.
Data Binding
ADO.NET / SQL / Custom Objects
Data Binding
The DevExpress Spreadsheet control allows you to bind a worksheet or cell range to various data source types: ADO.NET data sets, SQL databases, custom objects, etc. A cell range can also be used as a data source for any data-aware control. All data-related modifications affecting the worksheet are immediately propagated to bound controls. Changes made within external controls are immediately reflected in the worksheet.
Comments
Excel-Inspired Comments
Comments
You can annotate worksheets by using comments. End-users can add new comments, edit, hide or delete existing comments, move and resize the comment box.
Cell Formatting & Styles
Create professional-looking worksheets that display your data effectively.
Cell Formatting & Styles
The DevExpress Spreadsheet provides several fast and simple ways to create professional-looking worksheets that display your data effectively. You can use cell styles to apply predefined formats, and other manual formatting features to highlight important data.
Load/Save Documents
XLSX, XLS, XLTX, XLTM, CSV, TXT and more...
Load/Save Documents
The DevExpress Spreadsheet control supports the following file formats to import and export data:
- XLS, XLSX, XLSM;
- XLT, XLTX, XLTM;
- CSV;
- TXT;
- PDF (export only);
- HTML (export only).
"The response from DevExpress is always prompt, detailed and typically includes a code sample. Have used their suite for 4 years and never regretted my choice for one second."
Jim Thomas
Pivot Tables
Summarize, analyze, explore, and present your worksheet data.
Pivot Tables
An Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab reporting. Pivot Tables are highly flexible and can be quickly adjusted depending on how you need to display your results.
Functions & Array Formulas
Over 400 built-in functions. Custom functions.
Functions & Array Formulas
Numerous built-in functions (mathematical, statistical, financial, logical, etc.) allow you to enter formulas and perform calculations of any complexity.
The WPF Spreadsheet API allows you to create your own functions. Custom functions are available for all spreadsheet calculations, and can be used in formulas. Custom functions are not saved in a workbook file, and should be added in code.
Charts
Present information graphically within worksheets.
Charts
The DevExpress Spreadsheet control allows you to summarize worksheet data visually using a comprehensive collection of charts. Charts display data series visually to make it easier to understand large quantities of data and the relationship between different series of data.
Conditional Formatting
Highlight cell values for maximum data clarity.
Conditional Formatting
The DevExpress Spreadsheet ships with Microsoft Excel inspired Conditional Formatting support. This powerful feature allows you to highlight cells based on specified criteria without writing a single line of code. Cells can be highlighted with data bars, icons and predefined color scales. At runtime, end-users can easily apply style conditions by activating the Spreadsheet's popup menu.
Sorting & Filtering
Sort and filter data against worksheet columns.
Sorting & Filtering
As you would expect, our WPF Spreadsheet supports sorting against worksheet columns. You can sort data by text (alphabetically, according to the current culture), numbers, dates and time.
Filtering helps you to find information quickly. You can filter data in a range or table. Using built-in comparison operators such as 'greater than' and 'begins with' you can show the data you want and hide the rest.
Outlines
Arrange related columns or rows into groups and display summaries for each group.
Outlines
Outlining data makes your data easier to view. When you outline Spreadsheet data, you group worksheet data into different levels based on column and row headings. Once applied, you can expand the outline to view any pertinent detail data by clicking a plus sign. To collapse a group of cells, click a minus sign.
You can use the numbers to collapse or expand groups by level You can also quickly display as little or as much information by clicking the level symbols to the left of your worksheet.
"Since turning to DevExpress from a competitor I have been easily able to upgrade my clients systems, and provide features that were previously virtually impossible."
Justin Goddard
Spreadsheet Customization, Printing & Export
Custom Cell Editors
Deliver high-impact data editing experiences within your apps.
Custom Cell Editors
The DevExpress Spreadsheet control allows you to embed custom data editors into worksheet cells. You can use predefined in-place editors or handle the 'CustomCellEdit' event and assign your own editor to worksheet cells.
Text Search & Highlighting
Find / Replace
Text Search & Highlighting
A simple and quick way to find cell values. The 'Find and Replace' dialog removes all complexities associated with data searching. This dialog allows users to enter a search string and initiate a search against all values displayed in the worksheet.
WYSIWYG Printing
The easiest way to printing the contents of your workbook.
WYSIWYG Printing
Turn the contents of your workbook into a printed report with a simple method call or using the Print Dialog. You can customize and preview print output using the Print Setup dialog.
Headers & Footers
Add information to the top and bottom of a printed sheet.
Headers & Footers
The DevExpress Spreadsheet control allows you to add headers and footers at the top and bottom of a printed worksheet. You might create a header or footer that has page numbers, the date, and the name of your file using the Header/Footer dialog.
Print Titles
Make your printed copy easier to read.
Print Titles
Our Spreadsheet control allows you to specify rows and columns that will be printed on each printed page. This can make your printed copy easier to read.
Export to PDF
Data export is fully formatted.
Export to PDF
The DevExpress Spreadsheet control supports the following file formats to export data: