Find Root Element Name of Xml Map & Ignore Errors while Rendering Excel to PDF using Java

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 17.11.0. 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

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: http://www.aspose.com/products/cells/java

- Download Aspose.Cells for Java: http://www.aspose.com/downloads/cells/java

- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465

This release was published on openPR.