Aspose.Cells for .NET

Release Notes: This release includes support for tracing precedents and dependents cells in an Excel worksheet formula. It also supports new HTML table attributes (e.g. TH, ROWSPAN, etc.) for HTML-to-Excel conversion. Moreover, you can now ignore hidden columns when using the auto-fit column(s) feature. This release enhances the formula calculation engine and sorts out a few formulas, most notably VLOOKUP, OFFSET, ADDRESS, COUNTBLANK, IF, and NETWORKDAYS. It also improves the Excel-to-PDF conversion feature.

Release Notes: This release includes a number of enhancements for Pivot Tables and the formula calculation engine. 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. Also it adds (get/set) features for Pivot Tables. It has an improved formula calculation engine that you can use to calculate huge lists of formulas (in the template file) quickly. Also, you can take advantage of calculating formulas on your desired cells only.

Release Notes: This release includes a number of useful enhancements related to pivot table rendering and formula calculation. Support for pivot tables in Excel (97-2010) spreadsheets has been in Aspose.Cells for a long time. This module is being improved with every release of the product. This release adds support for the GETPIVOTDATA function. It enhances some pivot table options, e.g. DataDisplayFormat, AutoShowCount, Data Filtering, etc. It fixes the compatibility problems and other issues regarding pivot tables for different Excel file formats.

Release Notes: This release includes support for conditional formatting and cell gradient colors when rendering to PDF documents. It’s now also possible to copy ranges with validation set. The GridDesktop control provided by Aspose.Cells for .NET now supports conditional formatting. The PDFs created look like the original documents, even when they use advanced formatting. There are some other enhancements to how smart markers and error checking options are handled, especially for XLSM files. There's improved performance for the Excel-to-PDF and Excel-to-XPS features for various scenarios.

Release Notes: This release includes several enhancements and fixes a number of user issues/bugs. Some unnecessary older obsolete methods for the Sheet-to-Image feature are now removed. This release includes support for getting the document properties for an encrypted XLS file without even knowing its password. There are enhancements for the Smart Markers feature. You may now group data in some complex scenarios in which you also need to place dynamic rows for Sub-Totals, Totals, and Grand Totals in between the sections of data. The GridDesktop control provided by Aspose.Cells now supports shapes while loading Excel files.