A Complete WPF Spreadsheet With Over 500 Excel Functions

Create tables, apply table styles, calculate table formulas using structured references, and visualize your data with the built-in charts.

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

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.

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.

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.

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.

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.

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

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

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 in the cells and specify custom search options for match case, exact match, wildcards, search scope, search direction, and search values or formulas.

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

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

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.

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.

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.

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.