DevExpress V15.1:WPF Control Upgrade (ii)

< Download the latest version of DevExpress WPF Controls v15.1.5>

WPF Pivot Grid ControlExcel? Inspired conditional formatting

In the new version, we introduced a new easy-to-use approach to managing formatting rules at the design stage and at run time. The new Excel? The inspired conditional format allows your end users to sort and group data in a pivot grid, and visualize data cells with data bars, icons, and pre-defined or custom appearance schemes. Create, sort, and modify rules created by conditional formatting rules manager at run time.

The following comparison rules are fully supported:

• Above/below average-format only above or below average
• Top/bottom-only top or bottom rank value format
• Large/less-cell format with only the desired values
• Range-all cell formats based on values that use the color ruler, data bar, or predefined icons

OLAP performance improvements and custom server mode sequencing

In v15.1, we have significantly improved the performance of OLAP mode, and now pivot grid sorts data on the client. Receiving data faster when scrolling, filtering, sorting, grouping, and using a complex custom scheme also allows you to sort data in OLAP and server mode by using your own sorting algorithm.

In addition, you can now get user-defined member properties when querying the required data, which can improve the performance of your application.

WPF Spreadsheet ControlData Validation

WPF Spreadsheet Control now provides a data validation feature that you can use to prevent end users from entering invalid values into worksheet cells. With this data validation feature, you can create a drop-down list of allowable values, limit the number of characters entered into a cell, validate data using a comprehensive set of table formulas, and so on.

new Page Setup dialog box

In this release, you can use the New Page Setup dialog box to specify the relevant print settings for the worksheet (such as document orientation, paper size, margins, and so on).

headers and footers for documents

You can use the New Page Setup dialog box to insert headers and footers at the top and bottom of the worksheet that will be printed. The table control also supports specific code to include a header or footer with predefined information, such as page numbers, current date and time, file names, table names, and so on.

cut, copy, and paste operations for intersecting ranges

WPF spreadsheet controls allow 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.

API Improvements

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

WPF Scheduler Controltime Stamp

The time stamp action is consistent with the current-time indicator operation in MS Outlook.

Time zone Information

Appointments can be connected to time zone information, which is used to correctly calculate the start and end times of an appointment.

interested friends can click to see more devexpress articles !

DevExpress V15.1:WPF Control Upgrade (ii)