Key Features

Spread for WPF comes with a variety of features to make your applications faster and easier to use. WPF spreadsheet control includes support for import/export, full cell customization, an extensive calculation engine with a wide range of functions, and much more.

Some of the popular features are listed below.

• Import/Export Excel Files

  Support seamless import and export of spreadsheets to Excel and other file formats. This feature supports integrated printing with control over page orientation, margins, size, and header/footer text.

• Tables and Table Styles

  Create tables with built-in or custom styles to enhance the visual appeal and clarity of your data. You can also apply custom formatting options to highlight key information and improve readability.

• Charts

  Visualize data effectively with different chart types, such as Column, Line, Bar, Area, Stock, Surface, Histogram, Box, and many more.

• Merge Cells

  Give your worksheet a tidy look by merging the cells with the same values. Also, the Auto-Merge feature simplifies the process of merging duplicate content in adjacent cells. It automatically merges rows or columns with the same value.

• Data Binding

  Easily bind your worksheet to a data source of type IList, IEnumarable, or IBindingList. This dynamic capability ensures that your spreadsheet reflects real-time changes from the connected data source, enhancing data integration.

• Data Validation

  Add data validation rules in cells to maintain accuracy, allowing only specific entries from a list of values or valid range of numbers.

• Conditional Format Rules

  Use conditional formatting rules in cells and ranges to apply styles based on cell contents, making it easier to analyze the data. With icons, data bars, and color scales, this feature helps to quickly view table values.

• Formula Text Box

  Enable efficient formula editing in the active cell and highlighting cell using the Formula Text Box to improve readability.

• Cell Styles

  Customize the appearance of cells using built-in or custom styles, apply theme colors, different border styles, and also customize row and column header layouts with background colors, cell types, and text orientation.

• Built-in and Custom Themes

  Apply a built-in theme or create a custom theme to customize the look of the spreadsheet. Themes allow consistent styling of elements like split boxes, filter buttons, drop-downs, and more.

• Print Reports to PDF

  Design advanced reports that integrate tables, charts, and images, and print them directly or save as PDFs. The built-in print preview lets you adjust the layout before finalizing.