Overview of WPF Spreadsheet Control Features

• May 27, 2024
• 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.

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
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	[1]	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	[2]
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

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

2. Export is not supported.