Add Built-in Styles for WordArt Objects & Shadow, Glow, 3D Effects for Shape Object

What is new in this release?

The long awaited version of Aspose.Cells for Java 16.10.0 has been released. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. It has added support for reflection effects for a Shape object as Excel provides it via Effects tab under Format Shape dialog. In order to provide the said feature, it has exposed the ReflectionEffect class along with Shape.Reflection property which together controls the reflection effects of a Shape object. It has added the support for Shadow Effects for a Shape object as Excel provides it via Effects tab under Format Shape dialog. It has exposed the Shape.ShadowEffect property along with ShadowEffect class which together allows setting the shadow effect on a Shape object. Aspose.Cells for Java now supports the Glow Effects for a Shape object as Excel provides it via Effects tab under Format Shape dialog. It has exposed the Shape.Glow property along with GlowEffect class which together allows to set the glow effect on a Shape object. Aspose.Cells for Java supports the 3-D Formats for Shape objects as Excel provides it via Effects tab under Format Shape dialog as shown on the blog announcement page. It has exposed the Shape.ThreeDFormat property along with ThreeDFormat class which together allows to set the 3D formatting for a Shape object. The APIs now support to add WordArt objects with built-in styles. In order to provide this feature, the APIs has exposed the ShapeCollection.AddWordArt method along with PresetWordArtStyle enumeration which together allows adding preset WordArt objects since Excel 2007. Microsoft Excel application allows the automatic proprgation of formulas when new rows are inserted to a ListObject/Table. Aspose.Cells now provides the same feature by exposing the ListColumn.Formula property with this release. A few of the worth mentioning enhancements are ability to detect if spreadsheet contains hidden external links, adding XML map to spreadsheet and link cell to XML map elements, setting preset WordArt styles to shape’s text and Handled a few exceptions such as NullPointerException, IndexOutOfBoundsException & ClassCastException for certain scenarios. This release includes several enhanced features and bug fixes as listed below

- Refreshing PivotTable is not working in the rendered PDF file
- XLSM becomes corrupted by simple load and save operation
- Hyperlinks are not working as expected after converting spreadsheet to HTML
- Some characters do not render in the output PDF
- Order of chart legend changed in Chart's PDF
- Z order of high-low lines is not correct in PDF
- Spreadsheet becomes corrupted after re-saving with Aspose.Cells
- Formula is changed after inserting to a cell
- Strange behaviour with simple bean using Smart Markers
- NullPointerException while opening a7.xlsm file
- NullPointerException while opening a6.xlsm file
- NullPointerException while opening a5.xlsm file
- NullPointerException while opening a4.xlsm file
- NullPointerException while opening a3.xlsm file
- IndexOutOfBoundsException: Index: 23, Size: 14 while refreshing PivotChart

Other most recent bug fixes are also included in this release

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

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
[email protected]
Phone: 888.277.6734
Fax: 866.810.9465