Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Use ListObjects, PivotTables & AutoShapes Objects in Excel Reports

Reply
Thread Tools

Use ListObjects, PivotTables & AutoShapes Objects in Excel Reports

 
 
sherazam sherazam is offline
Senior Member
Join Date: Aug 2010
Posts: 183
 
      09-16-2011
What is new in this release?

The long awaited version of Aspose.Cells for Java 7.0.0. has been released. This is the first release in which we have automatically ported from our .NET code and therefore, it contains several features that were missing in the previous Aspose.Cells for Java versions. This release is a major milestone because from now on we can work more efficiently and it means a much better Aspose.Cells for Java for you. The reason for this is that we can now maintain two products – Aspose.Cells for Java and Aspose.Cells for .NET – from a single source code base. From now on the two products include almost the same set of features, fixes and are released on the same day. It is not common practice for us to make breaking changes to the API and we always try to avoid this whenever possible, but sometimes it is necessary. The changes this time occurred to make a move towards using the Aspose Unified Framework which dictates an improved API for loading and saving. This makes for a more organized and consistent API to be used across all Aspose products. The source code from the .NET platform will now be automatically ported to the Java platform. This will enable Aspose.Cells for Java to match Aspose.Cells for .NET feature-by-feature. This release includes plenty of new and improved features as listed below

- Separate compiled versions of the product for different JDKs, e.g. 1.4, 1.5, 1.6
- Set formulas with external references
- Support ListObjects / Tables
- Support AutoShapes Objects
- Enhancements are made for Shape-to-Image feature
- Enhancements are made for Chart-to-Image feature
- Enhancements are made for Sheet-to-Image feature
- Enhancements are made for Excel-to-PDF feature
- Enhancements are made for Auto-Fit Rows/Columns feature
- Enhanced Manipulate Tables
- Improved Read/Save Auto-Shapes, Chart-to-Image, Shape-to-Image features
- Support to add Text Box into Chart for XLSX file
- Copy PivotTables when copying Worksheets
- Select multiple items for PivotField
- Save Chart for Excel 2007 file
- Explicit Exception type for invalid password and file format when reading template file
- Remove “final” restriction for Worksheet/Font/Color classes
- Support to set ROUND/ROUNDUP/ROUNDDOWN formulas with only one parameter
- Support to get Validation for a specific cell, copy validations when copying cells range
- Sort data with more than three keys
- Support RTL languages for PDF
- Set HTML format value to cell
- Support to set Gradient Fill for a cell
- Line chart are saved as Line chart with data markers
- Read Number format incorrectly from ODS file
- Chinese characters for Chart-to-Image feature
- Render border and part of picture for PDF
- Render border and part of picture for PDF is fixed.

Other most recent bug fixes are also included in this release.

Known Issues/Limitations

There are a number of known limitations in this release. There are a few features that might not be supported in v7.0.0 that were actually supported in the older versions:

- Using LightCells APIs
- Reading HTML files
- Reading/Saving Charts/Shapes for ODS files
- Preserving Macros when reading ODS file and save Macros back to ODS file

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Conversion to PDF Files
- How to Create a PivotTable?

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java
- Demos of Aspose.Cells for Java
- Post your technical questions/queries to Aspose.Cells for Java Forum :
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
http://www.velocityreviews.com/forums/(E-Mail Removed)
Phone: 888.277.6734
Fax: 866.810.94651
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
How to launch reports (done with Crystal Reports) from a Java application? minjie@excite.com Java 2 03-15-2006 08:40 PM
Calling Crystal Reports in ASP.NET using the rptserver.asp given by Crystal Reports Peri ASP .Net 1 07-21-2005 12:56 PM
Displaying Microsoft Access Reports (active reports) via ASP.NET Brian Barnes ASP .Net 1 02-18-2004 05:59 AM
can not delete autoshapes in Excel 2002 SP-2 William Reitz Computer Support 1 11-28-2003 10:25 PM



Advertisments