What is new in this release?

The long awaited version of Aspose.Cells for Java 17.11.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 APIs. Aspose.Cells allows users to find the root element name of XML map using XmlMap.RootElementName property. Users can query cell areas mapped to xml map path with Aspose.Cells using the Worksheet.xmlMapQuery() method. If the path exists, it will return the list of cell areas related to that path inside xml map. The first parameter of Worksheet.xmlMapQuery() method specifies the xml element path and the second parameter specifies the xml map users want to query. Smart Art shapes are special shapes that allow to create complex diagrams automatically. Aspose.Cells allows users to detect Smart Art shapes and convert them to Group shape that enables users to handle smart art shape like a group shape. Consequently, users will have access to the individual parts or shapes of the group shape. Microsoft Excel allows users to create a shared workbook. When users share the workbook, then more than one user can edit the workbook. Aspose.Cells enables developers to create a shared workbook with Workbook.Settings.Shared property. Besides, users can protect or unprotect a shared workbook. Aspose.Cells allows to render sequence of pages of an Excel file to images using ImageOrPrintOptions.PageIndex and ImageOrPrintOptions.PageCount properties. These properties are useful when there are so many pages in an worksheet but users need to render a few pages only. This will not only save the processing time but also saves the memory consumption of the rendering process. Users can ignore all errors during the conversion process using the PdfSaveOptions.IgnoreError property. This way, conversion process will be completed smoothly without throwing any error or exception but data loss may occur. Below are some important new features, enhancement and bug fixes part of this release.

- ImageOrPrintOptions.PageIndex and ImageOrPrintOptions.Count properties needed to get the image of desired pages
- Exporting gridlines with borders do not display gridlines inside border in Excel to HTML rendering
- LightCellsDataProvider is removing leading and trailing spaces
- Incorrect font is used in the PDF output of MS Excel chart
- Some arrows or call-outs are missing in the output HTML
- 2nd comment is missing from worksheet comments collection
- Workbook creation seems to hang when reading from an XLSM file
- Style.QuotePrefix property does not work for XLSB file
- Setting the picture data affects the other chart and it displays wrong
- CheckBox.setName() method works in MS Excel 2016 but does not work in MS Excel 2007
- MS Excel filters are not converted correctly - XLSB to XLSM conversion
- Changing value of ComboBoxActiveXControl does not change the value of linked cell
- Cells.setColumnWidthPixel and Cells.setRowHeightPixel have different behaviors
- Extending table range unexpectedly mutates cell contents
- Exception: "java.lang.NumberFormatException" when loading an HTML file format
- Cells.deleteBlankRows is causing "java.lang.ArrayIndexOutOfBoundsException: 1937" exception
- Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded - File III
- Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded - File II
- Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded - File I
- Chart.toImage results in java.lang.ArrayIndexOutOfBoundsException
- Saving a Workbook as PDF after RemoveUnusedStyles API produces a CellsException
- "java.lang.IllegalArgumentException: Invalid row index" occurred
- Exception: "java.lang.IllegalArgumentException: Invalid row index" on saving an XLSX file format
- Exception: java.lang.NumberFormatException when re-saving an XLSB file format

Other most recent bug fixes are also included in this release

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.

- Find the Root Element Name of Xml Map
- Convert the Smart Art to Group Shape

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
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465