Aspose team is pleased to announce the release of Aspose.Cells for Java 17.6. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. We also recommend our clients use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Please check the release notes in order to get an idea about what is new and what has been fixed with this revision of Aspose.Cells for Java. Here is a look at the major features in this release.
Tile Picture as a Texture inside the Shape
Aspose.Cells supports image tiling feature which allows you to display images that are too large to be displayed entirely as a single unit on a typical computer. The feature allows you to display by segmenting it into smaller, more manageable image tiles.
//Load sample Excel file Workbook wb = new Workbook("e:\\test2\\Book1.xlsx"); //Access first worksheet Worksheet ws = wb.getWorksheets().get(0); //Access first shape inside the worksheet Shape sh = ws.getShapes().get(0); //Tile Picture as a Texture inside the Shape sh.getFill().getTextureFill().setTiling(true); //Save the output Excel file wb.save("e:\\test2\\out1.xlsx");
Please see this article that explains how to Tile Picture as a Texture inside the Shape.
Using Formula parameter in Smart Marker field
Sometimes, you need to embed formula in Smart Markers. Aspose.Cells allows you to make use of Formula parameter in Smart marker field. For more detail, please see this article.
Using OnAjaxCallFinishedClientFunction of GridWeb
OnAjaxCallFinishedClientFunction is a client side function which is called when user copies some data into Aspose.Cells.GridWeb worksheet. This function is helpful when bulk of cells are updated and you want to keep track of those updated cells at client side (i.e., in web browsers like FireFox, Google Chrome etc.). See the following document/article for your reference.
Other Enhancements and Fixes
Aspose.Cells 17.6 has enhanced its core for more stability as well as fixed many critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API. A few of the worth mentioning enhancements are as follow.
- Remove unnecessary older Web.config settings of Aspose.Cells.GridWeb like force script_path and forcepath.
- Group Rows in the worksheet – Aspose.Cells.GridWeb (JAVA).
- Handled an exception, “The row index should not be inside the pivottable report” when rendering to HTML file format.
- Handled an Exception, “java.lang.NullPointerException” when opening an ODS file via Aspose.Cells APIs.
- Handled NullPointerException on creating Workbook instance from source Excel file.
Furthermore, in this release, we have fixed several other issues. For example, issues around reading/writing MS Excel file formats, rendering shapes and drawing objects, rendering and manipulating charts, rendering HTML to Excel and vice versa, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. The formula calculation engine is further enhanced in the new release.
Changes to the Public API
This version of Aspose.Cells for Java has made some changes to the Public API. A few of the worth mentioning changes are as follow.
- Added GridWeb.OnAjaxCallFinishedClientFunction property that lets you get or set the client side function name to be called when ajaxcall is finished.
- Added enum StyleModifyFlag.RelativeIndent attribute that represents relative indent.
- Added TextureFill.setTiling property that indicates whether tile picture as texture.
Aspose.Cells for Java Resources
The resources, you may need to accomplish your tasks:
- Home of Aspose.Cells for Java API.
- Aspose.Cells for Java Download Section.
- Aspose.Cells for Java Documentation – up-to-date documentation containing Programmer’s Guide, Knowledge Base and much more.
- Aspose.Cells for Java API Reference Guide – detailing the publicly exposed classes, methods, properties, constants & interfaces.
- Aspose.Cells Product Family Forum – post your technical questions and queries, or any other problem you are facing while working with Aspose.Cells APIs.
- Enable Blog Subscription – do not limit yourself, you can keep yourself updated with the latest news on Aspose.Cells APIs, new features, fixes and other API related topics by subscribing to Aspose.Cells blog.
- Aspose.Cells for Java Examples – we have published our code examples on the social coding website GitHub.com. Anyone could explore the code examples for learning purposes.