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. Now, you can apply conditional formatting and filter data on Pivot Tables. Moreover, we have also supported some missing options (get/set) regarding Pivot Tables.
Formula Calculation Engine
In this release, we’ve improved formula calculation engine that you can calculate huge list of formulas (in the template file) in quick time. Also, you can take advantage of calculating formulas on your desired cells only.
We have fixed a number of issues posted by the users in the forums. You can convert worksheet to SVG format. The desktop based Grid control provided by Aspose.Cells for .NET, now, supports to read Excel files with grouping data options on. There are some other fixes and enhancements too. You’ll see a full list of fixes and enhancements from the list on the download page.