Aspose.Cells for .NET 7.0.4 improves formula calculation and pivot table handling

Aspose.Cells logoAspose.Cells for .NET 7.0.4 adds a number of useful enhancements, especially around pivot table rendering and formula calculation. 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.0.4

Pivot Tables Rendering

Support for pivot tables in Excel (97-2010) spreadsheets has been in Aspose.Cells for a long time. We are continuously improving this module with every release of the product. With this release, we’ve added support for the GETPIVOTDATA function. We have also enhanced some pivot table options, e.g. DataDisplayFormat, AutoShowCount, Data Filtering etc. We have fixed the compatibility problems and other issues regarding pivot tables for different Excel file formats.

Miscellaneous

We have improved the performance of Aspose.Cells formula calculation engine further. We have enhanced advanced conditional formatting rendering options. Rendering auto-shapes are improved while converting to PDF. Moreover, we have enhanced reading charts from ODS files. 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.