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 | ||||
Chart Sheets |
Worksheet Elements and Parts
Feature | Import, Export | Print, Export to PDF | Manage in Code | Manage in UI |
---|---|---|---|---|
ActiveX Controls | ||||
Charts | ||||
Custom XML Parts | N/A | |||
Defined Names | ||||
Document Properties | ||||
Form Controls | ||||
Freeze Panes | ||||
Headers/Footers | ||||
Hyperlinks | ||||
Macros | N/A | |||
Pictures | ||||
Pivot Charts | [1] | |||
Pivot Tables | ||||
Simple Notes | ||||
Shapes | ||||
Slicers | ||||
Smart Art | ||||
Sparklines | ||||
Tables | ||||
Text Boxes | ||||
Threaded Comments | ||||
Word Art |
Formulas and Functions
Feature | Import, Export | Print, Export to PDF | Manage in Code | Manage in UI |
---|---|---|---|---|
Array Formulas | N/A | |||
Built-In Functions | N/A | |||
Dynamic Arrays | N/A | |||
Nested Functions | N/A | |||
Shared Formulas | N/A | |||
Tracing Precedents/Dependents | ||||
User-Defined Formulas | [2] | N/A |
Chart Elements
Feature | Import, Export | Print, Export to PDF | Manage in Code | Manage in UI |
---|---|---|---|---|
Axis Titles | ||||
Chart Axes | ||||
Chart Legends | ||||
Chart Titles | ||||
Chart Templates | [3] | |||
Data Labels | ||||
Data Points / Custom Data Points | ||||
Data Series | ||||
Data Table | ||||
Error Bars | ||||
Gridlines | ||||
Trendlines |
Data Shaping Features
Feature | Import, Export | Print, Export to PDF | Manage in Code | Manage in UI |
---|---|---|---|---|
Filter Data | ||||
Outlines (Grouping) | ||||
Sort Data | ||||
Validate Data | ||||
Workbook/Worksheet Protection |
Formatting Features
Feature | Import, Export | Print, Export to PDF | Manage in Code | Manage in UI |
---|---|---|---|---|
Cell Styles | ||||
Chart Styles | ||||
Conditional Formatting | ||||
Format Cells | ||||
Page Setup Settings | ||||
Print Titles | ||||
Rich Text Cell Formatting | ||||
Table Styles | ||||
Themes (Fonts and Colors) |
Footnotes
-
Pivot charts are displayed and printed as regular charts.
-
You need to add a custom function to the CustomFunctionCollection collection before you load a document to successfully import this function.
-
Export is not supported.