Tag Archives: pivot tables

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

Posted on September 9, 2013 by Amjad Sahi

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 … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, maintenance release, pivot tables, product release

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

Posted on December 26, 2012 by Amjad Sahi

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.

This release is also a maintenance release where several important … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, formulas, pivot tables, product release

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

Posted on September 26, 2012 by Amjad Sahi

We proudly to announce the release of Aspose.Cells for .NET 7.3.2. In this release we have added support for copying sparklines 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. … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, formulas, pivot tables, product release, sparklines

Use RegEx Text Search in Excel Spreadsheets using Java

Posted on June 15, 2012 by Amjad Sahi

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.

To see a complete list of enhancements and fixes and … Continue Reading

Posted in Aspose.Cells Product Family | Tagged OLE, OOXML, java, pivot tables, product release, regex

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

Posted on June 14, 2012 by Amjad Sahi

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. We have also improved the Formula Calculation … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, XMP map, calculation engine, compatibility checker, pivot tables, product release

Use Regular Expression for Searching String in Excel using Java

Posted on May 17, 2012 by Amjad Sahi

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.Cells’ generated file compatible with POI. There are some other fixes … Continue Reading

Posted in Aspose.Cells Product Family | Tagged java, pivot tables, product release, regular expression, searching

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

Posted on May 17, 2012 by Amjad Sahi

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. We have also … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, calculation engine, input strings, pivot tables, product release

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

Posted on March 13, 2012 by Amjad Sahi

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 … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, conversion, performance, pivot tables, product release, ribbon XML

Aspose.Cells for Java 7.1.0 Includes Useful Enhancements and Fixes

Posted on January 18, 2012 by Amjad Sahi

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.… Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, conversion, pivot tables, product release

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

Posted on January 16, 2012 by Amjad Sahi

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 … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, calculation engine, pivot tables, product release