DevExpress v15.1:winforms Control feature upgrade (iii)

< free download DevExpress Winforms Controls v15.1.4>

WinForms Pivot Grid Controlnew Excel? Data export Engine

WinForms Pivot Grid Control uses a more powerful Excel data export engine. The new engine has been significantly improved in terms of performance and memory usage.

The following pivot grid features fully support all Excel export operations:

• Data grouping
• Fix columns
• Cell format-Export number format
• Choose whether to export the ability to display text or values

OLAP performance improvements and custom server mode sequencing

In the new version, the DevExpress WinForms pivot grid performs data operations in OLAP mode, which is faster than before because the data ordering is performed on the client. This accelerates data scrolling, filtering, sorting, grouping, and other data manipulation. You can also use a custom sort algorithm in OLAP and server mode to sort data.

WinForms Spreadsheet ControlData Validation

WinForms Spreadsheet Control now provides an efficient data validation option that you can use to prevent end users from entering invalid values in cells in a worksheet. With data validation, you can create a drop-down list of allowable values, limit the number of characters entered into a cell, validate data with a complete set of table formulas, and so on.

headers and footers for documents

With the new version of the Page Setup dialog box, you can insert headers and footers at the top and bottom of the printed worksheet. Spreadsheet control also supports specific code to include predetermined information in headers and footers, such as page numbers, current date and time, file names, worksheet names, and so on.

The New Page Setup dialog box

You can now use the Page Setup dialog box to specify settings related to the printed worksheet (such as document orientation, paper size, margins, and so on).

cut, copy, and paste operations for intersecting ranges

WinForms Spreadsheet control allows you to cut, copy, paste, move, and drag cells when the source range and target range intersect or the source range is within the target range. Specifically, you can use the Paste Special dialog box or move the selected cell range in the worksheet to replace the calculated value of the formula without losing any data.

Improved API

• Sparkline API: Create and modify different types of sparkline groups in your code.
• Error Checking API: Disables the bug checking option for specific cells by selecting a formula error type that is ignored in scope.

WinForms treelist ControlExcel? Inspired Format Rules dialog box

WinForms Treelist Control now provides the Excel Inspired dialog box to edit formatting rules.

querying columns and bands in custom forms

In this release, we have expanded the functionality of the custom form, which includes a search box so that users can quickly locate the grid's columns and bands.

Interested friends can click to see more devexpress articles!

DevExpress v15.1:winforms Control feature upgrade (iii)