ctodx

This Blog

News

Favorite Posts

Archives

WinForms and WPF Spreadsheet Control – Exciting New Features Coming Soon in v16.2

Microsoft Excel: ubiquitous, powerful, and familiar. Given its prevalence and breadth of functionality, there’ll always be a new feature to add to the DevExpress WinForms and WPF Spreadsheet control and for v16.2 it seems our dev team have gone above and beyond. Even so, I’m going to guess that the first feature I will introduce will have you installing the beta without hesitation.

Two-Way Data Binding

With this release, you can now bind a worksheet or specific range of cells to a standard data source. And that binding works both ways: for both reading and updating of data. While that sinks in, let me point out a few benefits. Last time, in v16.1, we added integrated cell editors. Suddenly you could create “forms” inside your spreadsheets and within your app. Data Entry forms, for example. Your users are up to speed with the whole spreadsheet UX (user experience), so designing forms in that familiar environment makes sense. And now, the data they enter can be read from and stored in your database, not just in the spreadsheet. It becomes shared. If you like, the spreadsheet is no longer an island, but is a gateway to the data you are already storing and processing.

We’ve gone even further: A cell range inside an open spreadsheet in the control can also be used as a data source for any DevExpress or third-party data-aware control (so the Data Grid, Charts, etc) in your app. All data-related modifications affecting the worksheet are immediately propagated to bound controls and changes made within external controls are immediately reflected in the worksheet. The Spreadsheet control and its documents become highly integrated in your app.

Another example before I move on: invoicing. This involves gathering data, often row-oriented data with summation, discounts and the like. That data is important, so much be saved in the database. Then there’s the need to generate the invoice as a report to be sent out. Which leads to…

Print Titles

The v16.2 DevExpress Spreadsheet control allows you to print titles for documents. If the worksheet is large enough to spread across two or more pages in the printed report, the titles (row and/or column headings) can be repeated on subsequent pages.

Print titles in WinForms and WPF Spreadsheet Controls

New Formatting Rule Dialog

The Spreadsheet control in v16.2 ships with a new Formatting Rule dialog. This dialog helps end-users customize the appearance of cells and by using conditional formatting.

Format Condition Dialog in WinForms and WPF Spreadsheet Controls

XLSX/XLSM File Encryption

Finally, in v16.2 we’ve added the ability to encrypt the spreadsheets created by the Spreadsheet Control. You can encrypt documents using either standard or agile XLSX/XLSM encryption.

Encryption in WinForms and WPF Spreadsheet Controls

Published Nov 30 2016, 11:00 AM by
Filed under: , , ,
Bookmark and Share

Comments

Scott G Blood

Is the encryption available in the standard exports used for excel documents in the XtraGrid and XtraPivotGrid, seems these should now be common code bases?

November 30, 2016 1:57 PM

Jerry Langland

Two way data binding is a dream come true.  I've literally been dreaming about this for a long time!  Shocked/surprised and happy to see it, although I'm a bit scared by it knowing my users....

So, now that you are about to deliver it for WinForms and WPF; how many versions before it makes it to the web spreadsheet?  (Aren't customers demanding?)

November 30, 2016 5:22 PM

DIP_Michel

Thumbs up! Two-Way Data Binding - We've all been waiting for this day!

November 30, 2016 10:46 PM

About Julian Bucknall (DevExpress)

Julian is the Chief Technology Officer at Developer Express. You can reach him directly at julianb@devexpress.com. You can also follow him on Twitter with the ID JMBucknall.
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