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.
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](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Chart Sheets |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Worksheet Elements and Parts
Feature |
Import, Export |
Print, Export to PDF |
Manage in Code |
Manage in UI |
ActiveX Controls |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
Charts |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Custom XML Parts |
![yes](/WPF/images/yes.png) |
N/A |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Defined Names |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Document Properties |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Form Controls |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Freeze Panes |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Headers/Footers |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Hyperlinks |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Macros |
![yes](/WPF/images/yes.png) |
N/A |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
Pictures |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Pivot Charts |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
Pivot Tables |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Simple Notes |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Shapes |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Slicers |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
Smart Art |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
Sparklines |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Tables |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Text Boxes |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Threaded Comments |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Word Art |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Feature |
Import, Export |
Print, Export to PDF |
Manage in Code |
Manage in UI |
Array Formulas |
![yes](/WPF/images/yes.png) |
N/A |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Built-In Functions |
![yes](/WPF/images/yes.png) |
N/A |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Dynamic Arrays |
![yes](/WPF/images/yes.png) |
N/A |
![no](/WPF/images/no.png) |
![no](/WPF/images/no.png) |
Nested Functions |
![yes](/WPF/images/yes.png) |
N/A |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Shared Formulas |
![yes](/WPF/images/yes.png) |
N/A |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Tracing Precedents/Dependents |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
User-Defined Formulas |
![yes](/WPF/images/yes.png) |
N/A |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Chart Elements
Feature |
Import, Export |
Print, Export to PDF |
Manage in Code |
Manage in UI |
Axis Titles |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Chart Axes |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Chart Legends |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Chart Titles |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Chart Templates |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Data Labels |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Data Points / Custom Data Points |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Data Series |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Data Table |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Error Bars |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Gridlines |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Trendlines |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Data Shaping Features
Feature |
Import, Export |
Print, Export to PDF |
Manage in Code |
Manage in UI |
Filter Data |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Outlines (Grouping) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Sort Data |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Validate Data |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Workbook/Worksheet Protection |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Feature |
Import, Export |
Print, Export to PDF |
Manage in Code |
Manage in UI |
Cell Styles |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Chart Styles |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Conditional Formatting |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Format Cells |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Page Setup Settings |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Print Titles |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Rich Text Cell Formatting |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |
Table Styles |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
Themes (Fonts and Colors) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![yes](/WPF/images/yes.png) |
![no](/WPF/images/no.png) |