Windows Forms New Features - 2008 Volume 3

You've asked for it and we've delivered! This new release of our NetAdvantage Windows Forms controls is all about Excel. We've added support for the latest file formats, .NET 3.0-native assembly builds and numerous enhancements that will be of great interest to WinCalcManager™ developers and users of the our Infragistics.Excel class library. We've made it easier to create workbooks containing Excel functions and to export the data grid to Excel. Read on to learn about all of the just-added features!

 

Microsoft Excel 2007 File Formats – NEW!

NetAdvantage Windows Forms controls now support of the latest File Formats for Excel (.xlsx, .xlsm) which allow exporting directly to the modern format and the ability to take advantage of the new larger amounts of rows it brings. Because we use .NET Framework 3.0 classes to support these File Formats, this feature will only be available when using the Infragistics.Excel and Excel Exporter assemblies built for CLR 3.0 (see next section).

Export data to the latest file formats (.xlsx, .xlsm) and take advantage of the larger amount of rows provided.

 

.NET 3.0 Assembly Builds for Infragistics.Excel and Excel Exporter – NEW!

We're taking advantage of .NET Framework 3.0 for some of our new features relating to the Infragistics.Excel class library and Excel Exporter component. Consequently, these NetAdvantage Windows Forms controls are now available as two separate builds, one for the CLR 2.0 and another for CLR 3.0 so that you can choose the assemblies right for you. Only the new Microsoft Excel 2007 File Format features require the .NET Framework 3.0 to be installed, and therefore this functionality is only available in the new CLR 3.0 assembly builds of the Infragistics.Excel class library and Excel Exporter component.

 

Seamless WinCalcManager-to-Excel Formula Integration – NEW!

WinCalcManager and integration has become more powerful now that we have added the ability to translate formulas from WinCalcManager to Excel automatically. Now when you export a WinGrid™ column summary formula such as [Price] + [SalesTax] you can expect it to be translated into your Workbook as a formula.

Translate formulas from WinCalcManager to Excel automatically.

 

Excel Formula Solving – NEW!

The Infragistics.Excel class library can now pull data from Excel and translate any of the formulas it encounters in the workbook, solving them for their formula value instead of representing them as strings.

 

Round-trip VB Macro Serialization – NEW!

In the latest release of the Infragistics.Excel class library, VB macros stored in your Workbook file can now be persisted or "round-tripped" so that they are retained after you have modified the Workbook (or its contents) with Infragistics.Excel and later serialize your changes back to file.

 

WinCalcManager Built-In Formulas – More Added!

WinCalcManager in NetAdvantage for Win Client 2008 Vol. 3 now includes a much larger number of built-in UltraCalcFunctions. Perform more complicated arithmetic, statistical or financial operations on your data, and improve your productivity and the value you can deliver to your end users. The underlying math can be completely handled by the enhanced built-in capabilities, and it negates the need for you to write a lot of lengthy custom code on your own.

Perform more complex operations on your data and improve end user productivity.