Add Cells to MS Excel Formula Watch Window, Create & Render Slicers in Spreadsheet using .NET

What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 18.6. It has supported to add Microsoft Excel Formula Watch Window for the users. Moreover, it has included some important fixes and other enhancements for the users. Slicers are a strong way to filter pivot table data. You can insert slicers into MS Excel to quickly and easily filter pivot tables. Aspose.Cells now supports to create, manipulate and render Slicers in the spreadsheet. Please see the sample code on blog announcement page. It loads the sample Excel file that contains the pivot table. It then creates the slicer based on the first base pivot field. The following sample code loads an Excel file that contains an existing slicer. It un-selects 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. spose.Cells also supports rendering of slicer shape. When users convert a worksheet into image or save a workbook to PDF or HTML formats, Users will see, slicers are rendered properly. MS Excel Watch Window is a useful tool to watch the cell values and its formulas conveniently in a window. Users 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.CellWatches.Add() method to add cells into Watch Window using Aspose.Cells API. 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. Please use Workbook.CustomXmlParts.Add() method if users want to add Custom XML Part using Aspose.Cells API. 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. Then users may 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.Text property. There are some other enhancements included and a few exceptions handled in the new release for the users, such as improve converting line Callout to image, WorkbookRender.ToImage(pageIndex, fileName/stream) and Bitmap WorkbookRender.ToImage(int pageIndex) methods included, Support DateTimeOffset format when importing custom objects, Handled EndOfStreamException when Aspose.Cells.Dll (latest assembly) is ilmerged, Exception: “File is corrupted” when loading an XLS file and ArgumentOutOfRangeException when Aspose.Cells (latest assembly) is ilmerged. This release includes several enhanced features and bug fixes as listed below

• Render Slicer shape to image format
• Update Slicer in XLSB and XLSX file formats
• Create Slicer in XLSB and XLSX file formats
• Create or update Slicer in Excel 2013 using Aspose.Cells
• Add API to get & set CustomXmlPart ID
• Improve converting line Callout to image
• WorkbookRender.ToImage(pageIndex, fileName/stream) and Bitmap WorkbookRender.ToImage(int pageIndex) methods included
• Support DateTimeOffset format when importing custom objects
• GroupShape definition is misleading
• Relevant methods in Aspose.Cells API are added for GetRangeAddess(), GetCellCount(), GetEntireAddress() and GetOffset()
• Convert smart art from XLSX to XLS file format
• Convert smart art from XLS to XLSX file format
• Ink tools disappeared when converting to PDF
• Portions of the picture in the spreadsheet renders in different color while converting worksheet to image
• Ink Objects does not render while converting spreadsheet to PDF format
• Some shapes are missing and some are dispersed (dis-positioned) - Excel to HTML conversion
• When Issue4 callout placement.xlsx converted to PDF, formatting is not good
• Displaced bigger image on converting an XLSM to PDF
• 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
• All previous columns and rows data stay in the PivotTable after filtering
• Output HTML is good in Chrome but wrong in IE or Edge
• Rows imported to single cell when importing HTML file format
• Cell value truncated when importing HTML
• Single quotes disappear from the formula when opening the file
• Formulas (containing linked data source in other workbooks) are not calculated fine
• Tab bar becomes hidden when user changes tab because Grid height grows up
• Print from Aspose.Cells differs from Excel
• PDF output ignores all the page breaks inside an MS Excel file
• Shape color changes when convert to PDF file format
• Excel document is slipping while saving as PDF
• Mixture of page 1 and page 2 in the output PDF
• Single word is splitted into two lines in Aspose.Cells' rendered output image
• Unable to load password-protected ODS file
• Pareto chart does not display in MS Excel file but it renders somewhat fine in PDF
• The chart horizontal axis label is corrupted
• Saving XLT file as XLS after clearing chart's data series causes red "Protected View" warning
• Watermark works fine with the spreadsheets but nothing shows up on charts
• Y-axis ticks in chart image do not match with MS-Excel
• CellsException - System.OutOfMemoryException while converting Excel file to PDF
• Pie chart legend colors change after saving to PDF and do not match up with pie chart slices
• Saving an XLT/XLTX file as XLS/XLSX causes red "Protected View" warning
• Hyperlinks are corrupted when referencing to sheet with special characters in its name
• Standardized way for last three numbers in the signature shape name
• Resizing headless table corrupts the output MS Excel file
• Output Excel File is corrupt after creating list object
• When render an Excel document to PDF, the process never finishes

Other most recent bug fixes are also included in this release

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. You can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET: http://www.aspose.com/products/cells/net

- Download Aspose.Cells for .NET: http://www.aspose.com/downloads/diagram/net

- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/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.