WinForms Spreadsheet Overview

Thank you for choosing Telerik RadSpreadsheet!

RadSpreadsheet is a control that allows editing tabular data utilizing a variety of cell formatting options, styles and themes.

Telerik UI for WinForms Ninja image

The Spreadsheet is part of Telerik UI for WinForms, a professional grade UI library with 160+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.

WinForms RadSpreadsheet Overview

RadSpreadsheet requires .NET Framework 4.0 and cannot be used with an older version.

Some of its features are:

  • Named Ranges

  • Protection: Different options available for protecting the workbook and its worksheets from modifications.

  • Shapes and Images: The UI enables you to work with images. API for insertion, positioning and deletion of images in worksheets.

  • Document themes

  • Freeze panes

  • Create and use multiple sheets, each one with its own history stack

  • Selection and active cell

  • Scrolling - there are two scrolling modes - ItemBased and PixelBased. The first one ensures that the whole content of the top left cell is visible, the latter designed for smoother interaction

  • Insert and delete cells, rows and columns

  • Merge cells, merge cells across columns and unmerge

  • Resize rows and columns, auto fit

  • Use different cell formatting

    • Various fonts and font sizes

    • ForeColor and background color

    • Bold, italics and underline

    • Vertical and horizontal cell alignment

    • Text wrapping

    • Cell borders

    • Use cell styles and themes for a more consistent look.

  • A battery of data formatting options:

    • Number

    • Currency

    • Accounting

    • Date

    • Time

    • Percentage

    • Fraction

    • Scientific

    • Text

    • Special

    • Custom

  • Auto fill and Series - fill cells automatically with data following a specific pattern

  • Data Validation: Enables you to control the type of data or the values that users enter into a cell. Different data validation rules are available, including list, number, date, text length or custom rules.

  • A broad range of formulas in different categories: Logical, Text, Date and Time, Math and Trigonometry. RadSpreadsheet comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well. For more information, refer to the Formulas section for SpreadProcessing.

  • Filtering worksheet data.

  • Sorting the data in the worksheet.

  • Find and replace data.

  • Copy/Paste: Add or copy worksheets within or across workbooks. Of course, copying and pasting of cells is supported as well.

  • Customize row/column headings.

  • Show/Hide grid lines and headers.

  • Zoom in and out each sheet separately.

  • Named Ranges: You can use the named ranges on workbook and worksheet levels.

  • Printing

  • Headers and Footers: The functionality enables you to add rich text content in the page margins when laying out a worksheet to pages.

  • Selection and active cell

  • Customizing the selection appearance

  • Easy integration with RadSpreadSheetRibbonBar

  • Localization: You can easily translate the string resources of RadSpreadsheet.

Telerik UI for WinForms Learning Resources

Telerik UI for WinForms Additional Resources

See Also

In this article