windowsforms-404980-controls-and-libraries-spreadsheet-product-information-feature-overview.md
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.
| Feature | Import, Export | Print, Export to PDF | Manage in Code | Manage in UI |
|---|---|---|---|---|
| Worksheets | ||||
| Chart Sheets |
| 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 | |||
| OLE Objects | ||||
| Pictures | ||||
| Pivot Charts | [1] | |||
| Pivot Tables | ||||
| Simple Notes | ||||
| Shapes | ||||
| Slicers | ||||
| Smart Art | ||||
| Sparklines | ||||
| Tables | ||||
| Text Boxes | ||||
| Threaded Comments | ||||
| Word Art |
| 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 |
| 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 |
| Feature | Import, Export | Print, Export to PDF | Manage in Code | Manage in UI |
|---|---|---|---|---|
| Filter Data | ||||
| Outlines (Grouping) | ||||
| Sort Data | ||||
| Validate Data | ||||
| Workbook/Worksheet Protection |
| 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.
Add a custom function to the CustomFunctionCollection collection before you load a document to successfully import this function.
Export is not supported.