Tag Archives: pivot table

Create and Manipulate Pivot Table, Apply Conditional Formatting, and Add Hyperlinks to Excel in C++

Aspose Team is pleased to announce the second major release of Aspose.Cells for C++ API. Aspose.Cells for C++ 16.12.0 has included many new features and enhancements that further improve the overall feature set of the API. Please check the detailed release notes in order to get an idea about what is new and what has been enhanced with this revision of Aspose.Cells for C++. If you are planning to upgrade the API from any previous version, we strongly suggest you … Continue Reading

Posted in Aspose.Cells Product Family | Tagged , , , , , ,

Customize Calculation Engine and Search Cells Based on Original Values in Excel – Android API

Posted on May 6, 2016 by Babar Raza
Aspose.Cells for Android logo

We are pleased to announce the release of Aspose.Cells for Android 8.8.0. This release includes a number of new features, enhancements and bug fixes that further improve the overall stability and usability of the API. Please check the release notes in order to get an idea about what is new and what has been fixed with this revision of Aspose.Cells for Android.

While you are downloading the latest build, here is a look at the biggest features in this … Continue Reading

Posted in Aspose.Cells Product Family | Tagged , , , , , , , ,

Aspose.Cells for Java 7.5.3 Maintenance Release

Aspose.Cells for Java logoWe are pleased to announce the release of Aspose.Cells for Java 7.5.3. This is a maintenance release that contains a few enhancements and fixes for issues reported in earlier versions. We resolved an issue caused by Aspose.Cells for Java’s formula calculation engine. A few other important issues have been addressed. For example, issues around rendering Microsoft Excel files and manipulating pivot tables have been resolved. Issues pertaining to the formula calculation engine have also been fixed in this … Continue Reading

Posted in Aspose.Cells Product Family | Tagged , , , ,

Change pivot items position, export group shapes and render conditionally formatted HTML using Aspose.Cells for .NET 7.0.0

Aspose.Cells icon

We have just released the Aspose.Cells for .NET v7.0.0. In this version, we have made some enhancements regarding Pivot Tables and Smart Markers. You can now change the position of the pivot table items. Aspose.Cells’ Exception handling is improved a bit and an exception will be thrown when you try to name a worksheet with special characters (that is not allowed in MS Excel either).

You can now render HTML files applied with conditional formatting. The performance of the Formula … Continue Reading

Posted in Aspose.Cells Product Family | Tagged , , ,

Format Pivot Tables and Utilize Advanced Auto-Filter Options using Aspose.Cells for Java 2.5.4

Aspose.Cells icon

We have released the Aspose.Cells for Java v2.5.4. In this version, we have added support for several advanced auto-filter types: MultipleFilter, DynamicFilter and IconFilter. Now, you can easily format a whole pivot table, toggle a pivot field’s items  between hidden/shown.  Moreover, you can specify axis’ properties as “Automatic” for Charts. The formula calculation engine is also enhanced, it now supports EOMONTH formula.

There are some other enhancements and fixes too.

Download URL: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/entry307071.aspx… Continue Reading

Posted in Aspose.Cells Product Family | Tagged , , ,