Render Worksheet Background & Improved Large Excel Files Rendering to PDF


Well-known member
Mar 10, 2010
Programming Experience
What is new in this release?

The long awaited version of Aspose.Cells for .NET 7.5.1 The new release includes a useful feature to get icon sets, data bars or color scales objects used when adding conditional formatting to a cell or a range of cells. We have also added support for rendering a worksheet?s background in an output HTML file. The component also supports parsing custom views and scenarios while converting from one Microsoft Excel file format to another. Moreover, we have improved the Excel to PDF rendering feature. It sometimes took more time to convert large Excel files to PDF. The product now does not take much time to convert large Excel files to PDF. In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel (2003 ? 2007/2010) file formats, rendering and calculating PivotTables, rendering charts, rendering image files from charts and exporting to PDF have been resolved. An improvement is also made to Aspose.Cells for .NET?s formula calculation engine. We have made a few enhancements and fix some bugs regarding edit cells where there is large dataset in the worksheet in the web based Grid control provided by Aspose.Cells for .NET. We have also fixed a bug in the acwmain.js file for certain features and operations. This release includes few enhanced features and plenty of bug fixes as listed below

- Get DataBar and ColorScale objects used in the conditional formatting
- How to get/read the Icons used in the conditional formatting for a cell
- Support Worksheet Background (Excel to HTML conversion)
- PivotTable.RefreshData() does not Refresh all PivotTable fields
- Parse Custom views in XLS to XLSM conversion
- Parse Scenarios in XLS to XLSM conversion
- XLSX to PDF conversion is improved
- Converting a 60MB Excel file to PDF/A ? OutOfMemoryException issue
- Workbook formulas now properly working
- Header image is now getting repeated in the PDF output
- Problems with Auto-size for the Textbox
- Language changes is resolved in XLS to PDF conversion
- PivotTable date formats wrong when there is more than one value item
- Some of the files generated through Aspose.Cells are producing errors are fixed
- PivotTable in the PDF output is now corrected
- Array formula(s) lost on Save is fixed
- Aspose.Cells removing the CustomUI14.xml file from the Excel workbook
- Chart axis values changing is fixed when saving from XLSX to PDF
- Negative number missing minus sign at web with Pie chart is fixed
- Chart labels and Legend difference between version v7.0.3.2 and v7.4.3.0 is fixed
- Recursive Reference errors are fixed after calling Workbook.CalculateFormula
- Apply Aspose.Cells.SortOrder to tables with an Array Formula
- File corruption issue is resolved on Save
- Files generated from a template file that contain a slicer need fixing
- Issues with Smart Markers with grouped data is resolved
- Aspose.Cells causes an Excel file to become corrupt is now fixed
- Copied cell values are different in target than the source is now fixed
- Array formulas are now calculated fine
- Issue f with creating a chart whose data source referenced in the other workbook
- PDF Generation improved with conditional formatting and Array formulas

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.

- Set Background Picture for a Worksheet
- Set Converting Excel to PDF Files

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 C#
- Product Overview of Aspose.Cells for .NET
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET
- Post your technical questions/queries to Aspose.Cells for .NET Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - Your File Format Experts
Phone: 888.277.6734
Fax: 866.810.9465
Top Bottom