More Enhancements for PivotTables Included in Aspose.Cells for .NET 7.5.3

Aspose.Cells for .NET 7.5.3 has been released. This month’s release includes an enhancement for reading and writing page setup options in HTML files. We have also made several enhancements for rendering, manipulating and refreshing PivotTables. We have fixed a few exceptions when reading and writing Excel files and manipulating PivotTables in a template file. In this release, several important issues have been addressed. For example, issues around rendering Excel files, rendering and manipulating PivotTables, rendering image files, converting Excel files to HTML/MTHML file format and exporting to PDF have been resolved.
September 9, 2013 · 1 min · Amjad Sahi

PowerPivot Feature, Read PivotTables in XLSB Files and Formula Calculation Engine Improved in Aspose.Cells for .NET 7.3.5

Aspose.Cells for .NET 7.3.5 has been released. This month’s release includes support for Microsoft Excel 2010’s PowerPivot feature: you can now read PivotTables in XLSB files. We have enhanced the Aspose.Cells’ formula calculation engine, so you can skip formulas whose external links do not exist in the template file. A number of bug fixes are also included in this release along with improved calculation of chart objects in template files.
December 26, 2012 · 2 min · Amjad Sahi

Copy sparklines between workbooks and other enhancements in Aspose.Cells for .NET 7.3.2

[![Aspose.Cells logo][1] between workbooks. We have also made an important enhancement to how protected ranges in the worksheet are handled: users can now set permissions for domain users/groups. Moreover, several important customer issues have been rectified. Many important issues with reading and writing Microsoft Excel files, manipulating charts, the Page Setup module and PDF export have been resolved in this release. Issues pertaining to Smart Markers and formula calculations have also been addressed.
September 26, 2012 · 1 min · Amjad Sahi

Use RegEx Text Search in Excel Spreadsheets using Java

We’re pleased to share the announcement of Aspose.Cells for Java 7.2.2. We have added a new feature to search text in the cells with Regular Expressions. We have added some other useful enhancements around conditional formatting and OLE embedded in OOXML files. The ExportObjectListener for saving HTML files has been made available in the latest version. We have also fixed a few issues regarding Pivot Tables, data validation and charts.
June 15, 2012 · 1 min · Amjad Sahi

Disable Compatibility Checker in Excel and Other Useful Enhancements using Aspose.Cells for .NET 7.2.2

We’re pleased to share the announcement of Aspose.Cells for .NET 7.2.2. We have added a new feature, disabling Microsoft Excel’s Compatibility Checker in this release. We have also added support for adding quotes around your data when saving to CSV format, as one of our customers asked us to. We have added some other useful enhancements around the Subtotals feature. The XML Map properties will now be retained when re-saving the template file.
June 14, 2012 · 1 min · Amjad Sahi

Use Regular Expression for Searching String in Excel using Java

We are pleased to announce the release of Aspose.Cells for Java 7.2.1. This month’s release provides support for applying custom formatting and styles to pivot tables. We have provided a new RegEx feature for when you’re searching for a string of a given pattern in the cells (of a worksheet). We have also made enhancements to chart rendering in ODS format. This release also sees enhancements that makes the Aspose.
May 17, 2012 · 1 min · Amjad Sahi

Input Large Strings and Other Enhancements in Aspose.Cells for .NET 7.2.1

We are pleased to announce the release of Aspose.Cells for .NET 7.2.1. This month’s release allows you to input strings larger than 32K for text and CSV formats. We have enhanced the shapes rendering module, specifically improving Excel-to-PDF conversion. We have also improved the Smart Markers feature so that Aspose.Cells for .NET now supports nested objects in Smart Markers. Moreover, we have made some enhancements regarding PivotTables and the internal Worksheet-to-Image modules and fixed some other issues.
May 17, 2012 · 1 min · Amjad Sahi

Create Tables in XLS Format and Customize the Ribbon XML using Aspose.Cells for .NET 7.1.2

We are pleased to announce the release of Aspose.Cells for .NET 7.1.2. This month’s release provides extensive support for tables in XLS format. You can now customize the Ribbon XML. There are some enhancements made for pivot table module. We have improved the performance for PDF rendering and loading large workbooks. Both the load and export processes are now fast enough to suit your performance needs. Aspoce.Cells Formula Calculation Engine has been enhanced further and we have fixed some bugs for certain formulas.
March 13, 2012 · 1 min · Amjad Sahi

Aspose.Cells for Java 7.1.0 Includes Useful Enhancements and Fixes

We have released Aspose.Cells for Java v7.1.0. In this release, we have incorporated several useful enhancements that improve we handle pivot tables, XLSX and ODS formats. We have also fixed issues regarding shapes, XLS, XLSX and ODS rendering. Moreover, we have further improved the Excel-to-PDF feature. There are some other fixes and enhancements too. To download and install Aspose.Cells for Java 7.1.0, go to the download page.
January 18, 2012 · 1 min · Amjad Sahi

Aspose.Cells for .NET 7.1.0 Supports Conditional Formatting and Data Filtering in Pivot Tables

Aspose.Cells for .NET 7.1.0 includes a number of enhancements for pivot tables. The formula calculation engine is further improved now. The rest of this article describes some of the features and enhancements that are in this release in more detail. You can download the latest Aspose.Cells for .NET release from the following link: Aspose.Cells for .NET 7.1.0 Pivot Tables Enhancements In older versions, you can utilize advanced conditional formatting (Excel 2007/2010) and filtering data features on general data but not on pivot data.
January 16, 2012 · 1 min · Amjad Sahi