Skip to main content
All docs
V24.1

Overview of WinForms Spreadsheet Control Features

  • 2 minutes to read

WinForms Spreadsheet Control is a feature-rich component. This article lists available workbook elements and workbook-related settings, and on which levels the Spreadsheet Control supports them.

Features that are not supported are excluded from this list.

Please refer to the following topic for information on supported file formats: Supported Formats.

Workbook Parts

Feature Import, Export Print, Export to PDF Manage in Code Manage in UI
Worksheets yes yes yes yes
Chart Sheets yes yes yes yes

Worksheet Elements and Parts

Feature Import, Export Print, Export to PDF Manage in Code Manage in UI
ActiveX Controls yes no no no
Charts yes yes yes yes
Custom XML Parts yes N/A yes no
Defined Names yes yes yes yes
Document Properties yes yes yes yes
Form Controls yes yes yes no
Freeze Panes yes yes yes yes
Headers/Footers yes yes yes yes
Hyperlinks yes yes yes yes
Macros yes N/A no no
Pictures yes yes yes yes
Pivot Charts yes yes[1] no no
Pivot Tables yes yes yes yes
Simple Notes yes yes yes yes
Shapes yes yes yes no
Slicers yes no no no
Smart Art yes no no no
Sparklines yes yes yes no
Tables yes yes yes yes
Text Boxes yes yes yes no
Threaded Comments yes no yes no
Word Art yes yes yes no

Formulas and Functions

Feature Import, Export Print, Export to PDF Manage in Code Manage in UI
Array Formulas yes N/A yes yes
Built-In Functions yes N/A yes yes
Dynamic Arrays yes N/A no no
Nested Functions yes N/A yes yes
Shared Formulas yes N/A yes yes
Tracing Precedents/Dependents yes no yes no
User-Defined Formulas yes[2] N/A yes no

Chart Elements

Feature Import, Export Print, Export to PDF Manage in Code Manage in UI
Axis Titles yes yes yes yes
Chart Axes yes yes yes yes
Chart Legends yes yes yes yes
Chart Titles yes yes yes yes
Chart Templates yes[3] yes yes no
Data Labels yes yes yes yes
Data Points / Custom Data Points yes yes yes no
Data Series yes yes yes yes
Data Table yes yes yes no
Error Bars yes yes yes yes
Gridlines yes yes yes yes
Trendlines yes yes yes no

Data Shaping Features

Feature Import, Export Print, Export to PDF Manage in Code Manage in UI
Filter Data yes yes yes yes
Outlines (Grouping) yes yes yes yes
Sort Data yes yes yes yes
Validate Data yes yes yes yes
Workbook/Worksheet Protection yes yes yes yes

Formatting Features

Feature Import, Export Print, Export to PDF Manage in Code Manage in UI
Cell Styles yes yes yes yes
Chart Styles yes yes yes yes
Conditional Formatting yes yes yes yes
Format Cells yes yes yes yes
Page Setup Settings yes yes yes yes
Print Titles yes yes yes yes
Rich Text Cell Formatting yes yes yes no
Table Styles yes yes yes yes
Themes (Fonts and Colors) yes yes yes no
Footnotes
  1. Pivot charts are displayed and printed as regular charts.

  2. You need to add a custom function to the CustomFunctionCollection collection before you load a document to successfully import this function.

  3. Export is not supported.