Spreadsheet Control - Telerik UI for WPF Components

Progress Telerik UI for WPF

Spreadsheet

MS Excel-Like Authoring

Provide Microsoft Excel-like authoring and editing in your applications with a smooth familiar interface for your end-users.
Formulas
There are more than 100 built-in formulas, covering a broad range of categories, which can meet even the most demanding requirements, including:
- Financial formulas
- Statistical formulas
- Engineering formulas
Sorting and Filtering

Organize and search data easily. Get a better understanding of data spanning across multiple rows and columns and quickly analyze data with the sorting functionality.

The filtering functionality enables you to add flexibility to your data. Display and focus on the data that you need at any given moment, without breaking its initial structure and content.
Copy/Paste

Copy-paste cells from a sheet with their formatting, using different paste options, all neatly organized in a drop-down in the ribbon view.
Number Formats

Manipulate, create and represent data in a variety of formats using any of the options for displaying numbers that RadSpreadsheet for Silverlight provides. All the main number formats are supported, including dates, currencies, percentages, text, and others.
Named Ranges

Define a name for a cell or range of cells, so you can easily remember and use it throughout your spreadsheet, instead of a cell reference.
Freeze Pane Support

To ease the user experience of working with multiple rows and columns, the RadSpreadsheet control for WPF now enables you to pin rows and columns in your worksheet.
Cell Formatting

Provide your end-users the ability to apply different fonts and font sizes, as well as foreground and background color for the text in the cells. This functionality is further enhanced by the ability to use styles and themes for a more consistent look-and-feel in the document.
Multiple Sheets and Undo/Redo

Your end-users have the ability to create and use multiple sheets, each one with its own history stack. Separate sheets can be edited at the same time, and every single action can be undone and redone.
Powerful Ribbon

The SpreadsheetRibbon control compliments Spreadsheet, with convenient ribbon exposing the variety of features the latter supports. With few lines of XAML you get all the UI expected from a standard spreadsheet editing application, including multiple ribbon tabs full of commands, styles gallery, formula and status bar. When updating from version to version, you'll automatically get UI for all the new commands we expose.

The Spreadsheet control provides convenient design-time experience – dragging Spreadsheet in the XAML designer will start code-generation wizard. You can choose a set of components, and all of the needed XAML code and assembly references are automatically added to the project.
Charts Support
The Spreadsheet component offers support for Charts to better visualize and summarize the data in the spreadsheet document to the end user in a visually appealing and understandable way. The functionality offers the ability to not only display charts, but also add and remove chart objects in the spreadsheet itself. The supported chart types are:

Column

Bar

Line

Pie & Donut
Area

Bubble

Stock
Export/Import
Save documents in three different formats to achieve best persistence of the data:
- Excel Microsoft Office Open XML Spreadsheet (.xlsx)
- Comma separated values (.CSV)
- Tab separated values (.txt)
- Portable document format (.pdf) - export only
Performance

Enjoy virtually no limitations on the number of cells in a sheet, providing unmatched performance--even with thousands of cells.
Printing and Print Preview

The new printing feature allows you to insert page breaks, define page areas and choose between numerous printing options. Virtual printers help you easily export your workbooks to different file formats.
Workbook and Worksheet Protection

Full support for Workbook protection allows you to ask for a password if users want to delete, add or rename worksheets. Worksheet protection allows you to apply a set of options that define what the user can do within the worksheet. You can allow users to change certain perimeters such as column weight and lock others such as row height for example. You also can make certain cells read-only to prevent users form changing their content.
Images Support

RadSpreadsheet allows your application users to easily insert and format images in their worksheets.