WPF Spreadsheet Top Features
This high-speed, optimized WPF engine calculates complex formulas with ease exactly like Excel and supports cross-workbook references.
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 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.
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.
Apply built-in cell styles using Theme colors, and create new custom Cell Styles with various accents to show and highlight your data.
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.
Apply cell borders with various styles and colors including bevel borders, double-line borders, outline borders, various border styles, and more.
Search in the cells and specify custom search options for match case, exact match, wildcards, search scope, search direction, and search values or formulas.
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.
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.
Create row and column range groups that can expand and collapse rows or columns to create vertical and horizontal outlines in the worksheet.
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.
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.
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.
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 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.