What is new in this release?
We are pleased to announce the new release of Aspose.Cells for .NET 8.2.0. This new release includes over 40 fixes and other enhancements. Aspose.Cells for .NET API is equally useful in multi-threading environment as well as in a single threaded execution plan. However, with recent changes to the core makes the API more reliable to read cell values in multiple threads simultaneously. Aspose.Cells for .NET has exposed the MultiThreadReading property for the Cells class in order to make sure that the correct cell values are always returned when API has to work in a multi-threading environment. For better elaboration, have a look at the detailed article on Simultaneously Reading Cell Values with Multiple Threads. Now you may also use new overloads (we have included in the new release) i.e., AutoFitRows(int startRow, int endRow, AutoFitterOptions options)/AutoFitColumns(int firstColumn, int lastColumn, AutoFitterOptions options) from the list(s) if you need to auto-fit your selected rows/columns with your desired AutoFitterOptions on accordingly. In the new version, we have fixed a few exceptions that occurred while opening Microsoft Excel files. We have fixed the Out of Memory exception while converting and Excel file to PDF file format. We have also improved the performance while manipulating large Excel files. In this release, several important issues have been addressed. For example, issues around reading/ writing MS Excel files (XLS, XLSX, XLSM, ODS etc.), copying worksheets, manipulating style and formatting in the cells and shapes, rendering and manipulating pivot tables, manipulating shapes and other drawing objects, rendering images from Excel worksheets, manipulating charts, rendering images files from charts, Page Setup options and exporting Excel workbooks to PDF format have been resolved. We have also fixed a few issues regarding Aspose.Cells formula calculation engine. We have also fixed a few issues in the web based Grid control provided by Aspose.Cells for .NET. This release includes few enhanced features and plenty of bug fixes as listed below
· An Overload of AutoFitRows Required
· The data validator list does not return expected values
· Unsupported excel 2013 function - Days
· Aspose.Cells hangs on Workbook.Save() method
· Large Excel file is corrupted when more than 45,000 rows are added
· Vertical Text in the spreadsheet is missing in the resultant PDF is fixed
· Text is now aligned inside the shape when XLS is rendered to PDF
· Rendered image is now clear in the output PDF
· Arrow objects are now positioned correctly in the output PDF
· Deleting rows and refreshing the pivot table crashes the output file is fixed
· Issue with Multi-thread reading values of cells in the worksheet are resolved
· Problem is resolved with Styled footer when spreadsheet is rendered as PDF
· The number of pages saved by Aspose.Cells PDF is 3.
· Tiff image spanning 4 pages instead of 2
· Shape overlapping the text in the resultant PDF is fixed
· Check Boxes are now aligned properly in the resultant PDF
· Image Quality decrement is fixed while saving spreadsheets to PDF
· Character e in graphic is now filled with black color
· #REF! error is resolved in Chart data source reference
· Chart issue is resolved on resaving ODS file
· Shape has shifted in the resultant PDF
· Change in Arrow direction in the resultant PDF is fixed
· The resulted PDF has a trimmed shape with a part of the cross not shown
· Bubble chart image doesn't created properly (Chart to Image) is fixed
· Saving an Excel XLSM file creates unreadable content error
· Leader lines are hidden when re-saving the template XLSX file is fixed
· End cell position changes from E9 to F9 is now fixed
· Aspose.Cells removed the Time Period Filters is fixed
· DeleteRange issue is resolved with Hyperlinks collection
· Built-in and Custom Document Properites are lost
· Name.GetRange is returning null instead of actual range
· Incorrect value calculation is fixed for COUNTIF formula while rendering to PDF
· Values are now properly calculated correctly by Workbook.CalculateFormula
· Worksheet.Copy now preserve the Chart correctly
· Incorrect values when reading line chart from workbook
· VLOOKUP function is evaluated as 0 as opposed to MS Excel
· XML Mappings lost is fixed when re-saving an Excel file
· Font of the Comment changes on resaving the ODS file is now fixed
· Chart's Series Formula Changes is resolved
· Chart Labels have changed the position/arrangement is now fixed
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.
- Converting Worksheet to Image: http://www.aspose.com/docs/display/cellsnet/Converting+Worksheet+to+Image
- Reading Cells Values in Multiple Threads Simultaneously: http://www.aspose.com/docs/display/cellsnet/Reading+Cells+Values+in+Multiple+Threads+Simultaneously
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, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. You can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.
More about Aspose.Cells for .NET
- Homepage of Aspose.Cells for .NET: http://www.aspose.com/.net/excel-component.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://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
Fax: 866.810.9465