WinForms Spreadsheet

Telerik UI for WinForms Spreadsheet control provides Microsoft Excel-like authoring and editing in your applications with a smooth familiar interface for your end users.

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

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 cells from a sheet with their formatting, using different paste options, all neatly organized in a drop-down in the ribbon view.

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

To allow better data visualization, the Spreadsheet control in Telerik UI for WinForms now enables you to add charts to your worksheet. 

The supported chart types are Column Charts, Bar Charts, Line Charts, Pie & Donut Charts, Area Charts, Scatter and Bubble Charts.

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.

Your end users can create and use multiple sheets. The Spreadsheet component also has a history stack which provides undo/redo operations.

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

Enjoy virtually no limitations on the number of cells in a sheet, providing unmatched performance—even with thousands of cells.

Printing in Telerik UI for WinForms Spreadsheet allows you to prepare and display spreadsheet data the most suitable way depending on your needs. Using different printing options such as defining the print page, the scale factor or whether to print grid-lines you may customize the way to present your data. Additionally, Print Area and Page Breaks allows to print only what you need to print and separate big documents on pages just the way you want your data to be separated.

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 from changing their content.

The Spreadsheet controls allows your application's users to easily insert and format images in their worksheets.