Overview of WPF Spreadsheet Control Features
- 2 minutes to read
WPF 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 | |
|
| OLE Objects | |
|
|
|
| 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.
-
Add a custom function to the CustomFunctionCollection collection before you load a document to successfully import this function.
-
Export is not supported.