DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio.

WinForms Spreadsheet Control Screenshots

WinForms Spreadsheet Control

A great spreadsheet demands a great charting engine and the XtraSpreadsheet delivers on that requirement with native integration of our award-winning charting suite. Not only will your charts closely match those of Excel, we've made certain that chart types and layouts are compatible with those available from Microsoft. And yes, when your spreadsheet needs an image or two, you can easily insert them into your worksheet for the “picture perfect” presentation of information.

Description

Straightforward and Easy-to-Use Spreadsheet

The DevExpress WinForms Spreadsheet is an Excel inspired control and allows you to introduce spreadsheet functionality to any WinForms 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.

Automated Formula Calculation Engine

DevExpress formula calculation results have been engineered to closely match those of Microsoft Excel. A spreadsheet formula is an equation that performs a calculation on numbers, functions and values of one or more cells. A formula is associated with a cell or a cell range. A formula is a string expression that begins with an equal (=) sign. A formula can contain the constants, operators, cell references, functions, and names.

Cell Formatting

The very best spreadsheets require proper formatting – not just to improve appearance but also to make information more readable and easier to consume. The XtraSpreadsheet is packed with a rich array of cell formatting options so your end-users can better understand the content of the worksheet and act on data as needed. The following cell format attributes are available:

Borders and background.
Font settings and content alignment.
Number formats (accounting, currency, percentage, etc.)

Built-in Spreadsheet Functions

The DevExpress Spreadsheet Control supports a comprehensive range of functions for use within formulas. Function categories include: Financial, Statistical, Engineering, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, Informational.

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

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.

Rows and Columns

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