Excel Advanced Conditional Formatting in PDF Documents Rendering

What’s new in this release?

The long awaited version of Aspose.Cells for .NET 7.0.3 has been released. It includes several enhancements and fixed number of user issues/bugs. It now added 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 (for Excel 2003 XLS format). The PDFs that you create 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. We have improved performance for Excel to PDF and Excel to XPS features for various scenarios so that converting large files is faster than ever. This release includes few new and plenty of enhanced features as listed below

  • Support MS Excel’s advanced conditional formatting in the generated PDF file
  • Support Cell Gradient Color that is not set properly while converting to PDF document
  • Uncheck Multi-level Category Labels while formatting Chart’s Axis
  • Enhanced Copy range with validation
  • Sorting & Dynamic formulas in Smart Markers is improved.
  • Implement ToString() method in the Cell, Range, Worksheet and other classes/objects
  • Enhancement - Excel95 - Excel 2003 file
  • Error checking options now working well with XLSM files
  • XLS to PDF or XPS performance is improved
  • Excel-to- PDF Performance is improved when number of worksheets increases
  • Hide pivot table columns issue is fixed
  • Charts images now match Excel’s charts
  • Opening XLSM file issue is fixed
  • The Style changing is fixed after merging or adding copy sheet to workbook operation
  • Opening and saving XLSM file throws away macros and ribbons is fixed now
  • Errors while saving Excel files are fixed
  • Pivot table refresh is improved
  • Charts now rendering fine in rendering / copying workbooks
  • Array formula references now updated on deleting a row or column
  • Chart disappearance is fixed after Save
  • Improved  saving XLSM file
  • Problems are fixed while refreshing Pivot table

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.

  - Creating Hierarchical View Sheet: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/creating-hierarchical-view-sheet.html

  - Using a Common Button to Submit Grid Data: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/using-a-common-button-to-submit-grid-data.html

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

- Homepage of Aspose.Cells for .NET: http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx

- Product Overview for Aspose.Cells for .NET: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/product-overview.html

-  Download Aspose.Cells for .NET:  http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx

- Online documentation of Aspose.Cells for .NET: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/index.html

- Demos of Aspose.Cells for .NET: http://www.aspose.com/demos/.net-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for .NET Forum:http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

Contact Information

Aspose Pty Ltd,

Suite 163, 79 Longueville Road

Lane Cove, NSW, 2066

Australia

http://www.aspose.com/

sales@aspose.com

Phone: 888.277.6734

Fax: 866.810.9465