What is new in this release?
The long awaited version of Aspose.Cells for .NET 7.6.0 has been released. The new release lets you select a different paper source when printing worksheets. Moreover, the collection objects are now Lambda/Linq friendly. We have added some significant enhancements for reading non-native Microsoft Excel files: now the component throws the appropriate exception when loading such files. We have improved the module for inserting OLE objects. This release also supports resampling images added to slides to reduce the overall file size and improve performance. So, if you want to compress images while saving Excel to PDF format. We have fixed a few exceptions as well when reading/writing Excel files and refreshing pivot tables in the template files. In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating pivot tables, converting Excel files to HTML format, rendering and manipulating charts, rendering image files from charts and exporting Excel workbooks to PDF format have been resolved. A few improvements are also made pertaining to the formula calculation engine. We have made a few enhancements and fixed some bugs regarding context menu in IE8 browser type. We fix an issue for the Undo button while calculating formulas in the web based Grid control provided by Aspose.Cells for .NET. We also included a few enhancements regarding formula calculations and formatting while importing Excel file in the desktop based Grid control provided by Aspose.Cells for .NET. This release includes few enhanced features and plenty of bug fixes as listed below
· Select a different PaperSource in Aspose.Cells
· Add collection objects to Lambda/Linq friendly
· PowerPoint file formats are detected now correctly by Aspose.Cells
· Publicize some older APIs (classes, methods etc.) after updating them (e.g. Shape.Paths, ShapePathCollection etc.)
· Inserting OLE Documents as linked – Issue resolved when updating SourceFullName attribute
· Set Excel VBS / CreateObject font color and cell's shading color
· Support Re-sampling for the added images to reduce the file size
· Calculation of the height (via CalculateTextSize() method) is incorrect
· Output PDF's PivotTable does not look the same as its original XLSX file
· improved saving an XLSX file as a PDF
· Pivot chart with Dates in X-axis now appear in the output PDF
· Pivot table's calculation field is now calculating correctly in the output PDF
· Pivot table's vertical alignment always resets to Center is now fixed
· PivotTables are now auto-fitting rows to display the word wrapped contents correctly
· The background color is not rotated but text is rotated in the HTML is now fixed
· The generated Excel file from HTML format now have defined Cell Names
· Subtotal row of Date columns in the PDF does not have the same Date formatting
· Insert blank lines not working in other Pivot columns other than the first in the output PF is now fixed
· Background color doesn't match in Excel if exporting to HTML is now fixed
· Generated PDF does not have the PivotTables' Page Breaks is now fixed
· SharedStrings are retained even after clearing data from the worksheet since v7.5.2.1 is now resolved
· XLS to PDF conversion prints all the pages instead of Print Area is now fixed
· Excel to PDF Arabic conversion issue is resolved
· Bug is fixed in converting Excel (RTL (Right-to-Left) format) to PDF
· Issue resolved with copying PivotTable in MS Excel 2010
· Text wrap setting is enhanced on refreshing PivotTable in Values' columns
· PivotTables in XLS files cause corruption is now fixed
· Half of the dates are correct, but the other half is formatted as numbers is fixed
· Graph data labels are now rendered correctly
· Problem with setting Gradient fill color in the Line chart type series
· Equation and RSquared are now hiding in the Trend Lines
· Incorrect Pie charts issue is fixed after conversion from XLSX to XLS
· Chart to Image conversion issue is resolved
· Data sorter obliterates rich text formatting is now fixed
· Excel syntax now supported by Aspose.Cells - it should print 360
· Excel found unreadable content in XLSX is now fixed
· DATEDIF function problem in Aspose.Cells for .NET is resolved
· Formula calculation is much enhanced
· Security Alert in MS Excel after converting the file is fixed
· Japanese Fonts' display problem is resolved
· "IFERROR(IF…" formula values now appear in PivotTable in output PDF
· Bugs resolved with right click menu and IE8 browser type
· Bug with Undo button in formulas' calculation is fixed
· Link to cells in the same workbook is fixed
· Enhanced ADDRESS formula's calculation
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.
- Resampling Added Images - Excel to PDF Conversion: http://www.aspose.com/docs/display/cellsnet/Resampling+Added+Images+-+Excel+to+PDF+Conversion
- Save Each Worksheet to a Different PDF File: http://www.aspose.com/docs/display/cellsnet/Save+Each+Worksheet+to+a+Different+PDF+File
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/.net/excel-component.aspx
- 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://docs.aspose.com/display/cellsnet/Home
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
[email protected]
Phone: 888.277.6734