Controls

MS Excel-Like Authoring

Provide Microsoft Excel-like authoring and editing in your applications, with a smooth familiar interface for your end-users.
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.
Formulas

There are more than 100 built-in formulas covering a broad range of categories that can meet even the most demanding requirements.
Copy/Paste
Copy-paste cells of 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 Spreadsheet control now enables you to pin rows and columns in your worksheet.
Cell Formatting
Give 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.
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 limitation on the number of cells in a sheet, providing unmatched performance even with thousands of cells.
Printing and Print Preview
The printing feature in RadSpreadsheet enables your application users to insert page breaks, define page areas and choose between numerous printing options. Virtual printers enable them to easily export 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 enables your application users to easily insert and format images in their worksheets.