: DevExpress WPF Spreadsheet Control
Automatically Generated UI

The DevExpress Spreadsheet provides the UI experience your end users have come to expect from today's most popular office productivity suite. It includes full integration with the DevExpress Ribbon control so you can quickly deliver stunning applications with minimal effort.


: DevExpress WPF Spreadsheet Control
Straightforward and Easy-to-Use Spreadsheet

The new DevExpress WPF Spreadsheet is an Excel inspired control and allows you to introduce spreadsheet functionality to any WPF application with absolute ease. It can load, convert and save workbooks to the XLS binary file format and can export and import XLSX, CSV and TXT files.


: DevExpress WPF Spreadsheet Control
Automated Formula Calculation Engine

DevExpress formula calculation results have been engineered to closely match those of Microsoft Excel. You can use formulas to calculate a cell value or evaluate an expression.


: DevExpress WPF Spreadsheet Control
Built-in Spreadsheet Functions

The DevExpress Spreadsheet Control supports a comprehensive range of functions for use within formulas. Functions are compatible with Microsoft Excel. You can also define your own functions.


: DevExpress WPF Spreadsheet Control
Cell References

A formula can contain references to other cells or cell ranges within the same or different worksheets. The following references are supported:

  • A1 and R1C1 References
  • Relative, Absolute and Mixed References
  • Cross-Worksheet References
  • 3D References
  • Structured References


: DevExpress WPF Spreadsheet Control
Worksheet Management

You can control the visibility of the worksheet gridlines, specify Row and Column headings and zoom in and out of a worksheet view. You can create, copy, rename and delete worksheets .


: DevExpress WPF Spreadsheet Control
Rows and Columns

You can insert, copy, and delete rows and columns, adjust row height and column width.


: DevExpress WPF Spreadsheet Control
Pictures

You can insert, move, change, transform and delete pictures embedded into a worksheet. Pictures can move and resize with cells. You can move pictures in different graphic layers.


: DevExpress WPF Spreadsheet Control
Cell Formatting

Proper cell formatting improves worksheet appearance, and allows end-users to read, find and understand worksheet data more easily. You can specify the following format attributes for cells:

  • Cell font settings (font name, size, color, style, etc.)
  • Cell background (color, pattern shading, gradient shading)
  • Cell content alignment (vertical and horizontal alignment, indent and text wrapping)
  • Cell borders


: DevExpress WPF Spreadsheet Control
Conditional Formatting

Conditional formatting is used to highlight important information and make data interpretation easier. Custom format, such as cell shading, borders or a font color can be applied to cells with values which meet certain conditions specified by the conditional formatting rule. Cell data can be displayed as data bars or as icons taken from the built-in icon set. Conditional formatting rules and appearance are compatible with MS Excel.


: DevExpress WPF Spreadsheet Control
Charting

Charts can help you display data in ways that are meaningful to your customer. You can select from a variety of chart types and built-in presets. Our native chart engine is used to display charts so that they closely match their appearance in Microsoft Excel. Chart types and layouts are compatible with Microsoft Excel charting.


Download the Free Trial

Includes 30 days of free tech support

Buy it Today

Part of the WPF Subscription
Pricing starts at only
Get started today and see why tens of thousands of developers
worldwide choose DevExpress.

$899.99

Everything you'll need for your next WPF project.

The 110 controls and libraries that make up the DevExpress WPF Subscription have been engineered to address the UI, analytics and reporting requirements for a broad range of solutions targeting Windows®, Download your free trial today or explore the individual controls that ship as part of this subscription below.
Office-Inspired
Create compelling business solutions that emulate the look, feel and capabilities of Microsoft Office®.
Reports & Analytics
Harness the power of information and present it to your users so it's always easy-to-use and always customizable.
Navigation & Layout
Reproduce the advanced and highly flexible user interfaces of today's most popular Windows applications.
LIVE CHAT

Chat is one of the many ways you can contact members of the DevExpress Team.
We are available Monday-Friday between 7:30am and 4:30pm Pacific Time.

If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

FOLLOW US

DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

Copyright © 1998-2017 Developer Express Inc.
All trademarks or registered trademarks are property of their respective owners