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

What is new in this release?

The long awaited version of Aspose.Cells for Java 18.6 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. 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

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

- Add Custom XML Parts and Select them by ID
- Add Cells to Microsoft Excel Formula Watch Window

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