WPF Spreadsheet Top Features

Powerful, Fast, Optimized Calculation Engine
This high-speed, optimized WPF engine calculates complex formulas with ease exactly like Excel and supports cross-workbook references.

350+ Functions in Customizable Library
Functions for every type of calculation, support for adding custom functions, and full customization for your formulas — take your complex spreadsheets to the next level.

No-Code Design with Spread Designers
With the powerful Spread Desktop Designer App, you’ll get code-free WPF spreadsheet apps and accelerate your application development.

Import/export Excel files into a .NET spreadsheet
No spreadsheet is complete without full Excel import/export support! Import and export your WPF spreadsheet to XLSX or other file formats... all with zero dependencies on Excel.

Print Reports to PDF
Create advanced report layouts with tables, sparklines, charts, and images using built-in print preview and then print to a local printer or PDF file.

Conditional Format Rules
Apply Conditional Format Rules in cells and ranges to apply styles based on the cell content or display icons, data bars, color scales in the cells to quickly visualize values.

Cell Styles
Apply built-in cell styles using Theme colors, and create new custom Cell Styles with various accents to show and highlight your data.

Sort and Filter
Add filtering and sorting drop-down in a table or range and enable your users to sort the values ascending or descending or select filter items.

Tables and Table Styles
Create tables using built-in table styles or create custom table styles to apply banded columns or rows and custom formatting to highlight your data.

Cell Borders and Gridlines
Apply cell borders with various styles and colors including bevel borders, double-line borders, outline borders, various border styles, and more.

Merge and Span Header Cells
Create multiple row and column headers and span cells in the headers to create grouped sets of rows or columns in a tabular report layout.

Search Cells
Search in the cells and specify custom search options for match case, exact match, wildcards, search scope, search direction, and search values or formulas.

Charts
Visualize your data with chart types including Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Bubble, and Radar, or create combination charts that combine various series types.

Sparklines
Visualize your data in a more compact way with sparkline charts that draw directly inside the cell – these tiny charts are perfect for including directly in tables and dashboard reports.

Data Binding
Connect to a data source and import data into your spreadsheet, or bind the worksheet to a data source of type IList, IEnumarable, or IBindingList.

Outline and Range Grouping
Create row and column range groups that can expand and collapse rows or columns to create vertical and horizontal outlines in the worksheet.

Themes
Apply one of 20 built-in themes or create a custom theme or XAML theme to customize the control's appearance including split boxes, filter buttons, drop-downs, and more.

Floating Objects
Create custom floating objects and images in the worksheet for process flow diagrams, cell callouts, and more, and save and load these objects in XLSX and XML files.

Formula Text Box
The Formula Text Box control attaches to the spreadsheet to provide separate control for viewing and editing formulas in the active cell and highlighting cell and range references.

Search
Show tooltips on resize of rows or columns displaying the height or width, and show tooltips on scrolling displaying the new top row or left column index.

Merge and Span Cells
Merge cells by applying a span cell to data area or header cells to create hierarchical tabular report layouts or tablix-type report layouts.

Cell Formatter
Apply cell format strings for number and date formats as in Excel and specify a separator, decimal point, currency symbol, date format, and more.

Data Validation
Add data validation in cells and specify the type of validation such as list range or valid range of numbers, input message, and error alert.

Names and Name Manager
Use names in your formula calculations to optimize your formulas and make them more readable, and use Name Manager to organize and manage your formula names.

Freeze Panes
Freeze rows and/or columns at the top or left of the worksheet and keep those rows and/or columns from scrolling out of view as the user scrolls down or right in the worksheet.

Split View
Create split views to show multiple areas of the worksheet at once regardless of how many rows or columns are between, that save and load with the XLSX.