Add Cells to Microsoft Excel Formula Watch Window & Working with Slicers using Java

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.6. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. Microsoft Excel Watch Window is a useful tool to watch the cell values and its formulas conveniently in a window. You can open the Watch Window using Microsoft Excel by clicking the Formulas > Watch Window. It has Add Watch button that can be used to add the cells for inspection. Similarly, users can use Worksheet.getCellWatches().add() method to add cells into Watch Window using Aspose.Cells API. Slicers are used to filter data quickly. It provides buttons that user can click to filter Table or Pivot Table data. Whenever, Slicer buttons are selected or deselected, it shows the current filtering state that helps the user to understand what precisely has been filtered in the Pivot Table. The sample code on blog announcement page loads an Excel file that contains an existing Slicer. It unselects the 2nd and 3rd items of Slicer to refresh it. It then applies formatting/style of the Slicer and finally describes on how to remove the Slicer. Custom XML Parts are the XML data that is stored inside the Microsoft Excel documents and are used by the applications that deal with them. There is no direct way of adding them using Microsoft Excel UI at the moment. However, users can add them programmatically in various ways e.g. using VSTO, using Aspose.Cells etc. Please use Workbook.getCustomXmlParts().add() method if users want to add Custom XML Part using Aspose.Cells API. Users can also set its ID, using the CustomXmlPart.ID property. Similarly, if users want to select Custom XML Part by ID, it can use Workbook.getCustomXmlParts().selectByID() method. Aspose.Cells has added few new utility methods inside the Range object that help the user finding Address, Cell Count, Offset, Entire Column and Entire Row of the Range object. Aspose.Cells can extract text from the Gear Type Smart Art Shape. In order to do so, users should first convert Smart Art Shape to Group Shape using the Shape.getResultOfSmartArt() method. Then users should get the array of all the Individual Shapes forming the Group Shape using the GroupShape.getGroupedShapes() method. Finally, users can iterate all of Individual Shapes one by one in a loop and extract their text using the Shape.getText() method. Below are some important new features, enhancement and bug fixes part of this release.

• Implement custom data sorting in Pivot Table report via Aspose.Cells APIs
• The implementation of the MS Excel feature 'Watch Window'
• Unable to extract the text from the gear type SmartArt
• Exception: "FormulaBuildUnknown formula token0" on Name.getRefersTo()
• Exception: "FormulaBuildMore than one token in stack...." on Cell.getFormula()
• Aspose.Cells accepts and corrects an invalid formula
• Some drawing shapes are displaced or rendered wrongly in Excel to HTML rendering
• Unable to extract Smart Art images correctly
• Shape is displaced to cover data in Excel to HTML rendering
• Calculation of formulas are wrong e.g. it generates #DIV/0! errors
• Cell A3 format is not correct in the output HTML
• Poor performance when generating PDF file from an MS Excel file
• XLSX to TIFF - exception NoClassDefFoundError
• Images are lost when Excel file is converted to PDF
• Chart.calculate method causes OutOfMemoryError
• Memory increases in rendering Excel file to PDF file format
• Font size changed on chart title due to characters() method
• Shadow effect is changed while re-saving XLS
• Excel to PDF conversion - the conversion never completes
• Unable to get or set alternative text for Comment shape
• Aspose.Cells hangs when converting a spreadsheet ml file (xml) to PDF with self-closing Styles tag
• Unable to set alternative text for SmartArt shape
• getFirstVisibleRow() and getFirstVisibleColumn() returning invalid indices
• Hyperlinks with encoded symbols (such as, "%5c") decode after re-saving

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.

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.