Export Encrypted PDF Files & Auto-Filters Support for Excel Files

What’s new in this release?

The long awaited version of Aspose.Cells for .NET 5.1.4 has been released. It includes support for encrypting the PDF documents and allows users to import/export Excel files with Auto-Filters. Moreover a large number of valuable functions/formulas are also supported in this release. This release includes plenty of new and improved features as listed below

  • Supports exporting encrypted PDF files.
  • Supports importing/exporting auto-filters in Excel files.
  • Enhances the performance of saving PDF files.
  • Supports clicking column header to select entire column, clicking top-left corner to select entire sheet’s cells similar to MS Excel’s behavior.
  • Provides support for iterative calculations.
  • Supports named ranges.
  • Allows obtaining data field name at client side.
  • Includes printing feature at client side.
  • Allows undoing changes by code.
  • Supports undoing changes of comments.
  • Provides support to set visibilities of comments.
  • Supports to set indent (style) while formatting cells.
  • Imports or exports pictures of Excel files.
  • Obsolete: NumberType, Custom and IsLocked properties of Aspose.Cells.GridWeb.Data.WebCell are obsolete. These properties are now added to Aspose.Cells.GridWeb.TableItemStyle.
  • Obsolete: Style attribute of Aspose.Cells.GridWeb.Data.WebCell is obsolete. The recommended alternatives are using Aspose.Cells.GridWeb.Data.WebCell.GetStyle() and Aspose.Cells.GridWeb.Data.WebCell.SetStyle() methods.

Other most recent bug fixes are also included in this release.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

Contact Information

Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose – Your File Format Experts
sales@aspose.com

Phone: 888.277.6734
Fax: 866.810.94651