AutoFit Rows/Columns in Worksheet & Saving Workbook to CSV is Enhanced
05/09/2013

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 & OLE objects.

Online PR News – 09-May-2013 – Lane Cove, NSW – What’s new in this release?

The long awaited version of Aspose.Cells for .NET 7.4.3 has been released. This month’s release includes an enhancement for copying a cell over a range of cells. We have added a new overload: AutoFitColumns (int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options), so you can use auto-fitting options even in a range. Similarly, you may now copy tables when copying ranges. We have also made enhancement regarding the Smart Markers’s Group Data feature. We have fixed a few exceptions when reading and writing Excel files and resolved an issue on Mono for the exception “Unknown Heap Type: SmartAssembly”. In the new release, several other important issues have also been addressed. For example, issues around rendering Excel files, rendering PivotTables and Pivot Charts, Excel to HTML conversion, applying conditional formatting, rendering image files from charts/worksheets and exporting to PDF have been resolved. Issues pertaining to the formula calculation engine have also been fixed. We have made a few enhancements in Aspose.Cells for .NET’s web based Grid control. For example, GridWeb now allows you to copy cell formatting (background color, alignment etc.) with data for its copy/paste feature. We also fix some bugs regarding cells selection, data validation and number formatting etc. in GridWeb. We have also improved GridWeb’s MS Ajax feature. We have also fixed a formula calculation issue in the desktop based Grid control (GridDesktop). This release includes few enhanced features and plenty of bug fixes as listed below

• Add new overload: AutoFitColumns(int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options)
• GridWeb’s Copy/Paste feature – cell formatting (background color, alignment) is copied with data
• When EnableAjax is set to be true, get the Active sheet before PreRenderComplete event
• Copy a cell over a range of cells
• Smart Marker Grouping
• Copy ListObjects/Tables in copying range.
• Saving Workbook to CSV is now keeping columns for each row
• System.OutOfMemoryException on loading the workbook
• Rendering PDF from Excel ignores Alpha
• Print area header and footer now appear when converting Excel to PDF
• Graphic now exported properly
• Excel Sparklines don't get saved in the rendered image is fixed
• Image Contrast now preserved when rendering image from Excel
• Some text/data is wrongly shared at the top
• Incorrect calculation is resolved of GETPIVOTDATA in Aspose.Cells 7.4.2.x
• Problem resolved for XLSX to HTML conversion
• Problem resolved for XLSX to HTML conversion II
• Problem with truncated cell text in the XLSX to HTML conversion is fixed
• Cells next to Pivot table are populated with Pivot table’s values is fixed
• Changing Pivot table’s data source will cause problems is fixed
• Set Table as Pivot Table's data source problem
• Issue resolved with Pivot ranges
• Pivot table’s formatting problem is resolved
• Calculated values are not accepted by Pivot table's RefreshData() method
• Error is fixed when saving an Excel file
• Excel to Html problem resolved - the cell's characters are over wrapped
• Pivot table borders are now properly visible in the PDF
• Pivot chart in the generated PDF is now the same as Pivot chart in the generated XLSX file
• Data series Line styles’ cap Type property is reset to default is now fixed
• Data labels appear outside of the chart area is fixed
• Changing the position of data labels is now properly working
• Issue with a custom font color of the legend entry for a particular series is resolved
• Hidden columns extracted as string data table have incorrect and empty values is now fixed.
• Conditional formatting issue is resolved
• After saving the file with Aspose.Cells, the last two columns move to the next page break is now fixed
• CalculateFormula is now working right
• Copying a range of columns that are grouped, the grouping options/attributes are now properly copied
• Values are hidden after saving an XLS file is now fixed
• Background of Ole Objects is change to blue is fixd after double-conversion (XLS->XLSM->XLS)
• Aspose.Cells nowt update formulas properly when deleting rows
• Excel formula optimizations in XLSX and XLS break formula calculations is fixed in this release
• Incorrect formula is fixed after deleting row when referencing a ListObject Header
• ActiveX controls now get copied when using Workbook.Copy(source)
• Cell.HtmlString - Font size in the Cell is now correct
• GridWeb OnCellSelected server event,row and col is correctted
• Aspose cells GridWeb improper selection is fixed
• Aspose.Cells.GridWeb's improper selection of cells is fixed
• Now all the worksheet’s properties are properly preserved
• GridWeb validations pop up items list does show at correct position
• GridWeb Issue with acwmain.js file in IE10
• Word wrap alignment issue in GridWeb is resolved
• GridWeb page shrinks after clicking save Excel button and then viewing Excel button is resolved
• Aspose.Cells.GridWeb - custom number formats are now working
• Aspose GridWeb issue - Not able to delete and insert values in an ASP.NET TextBox is 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.

- Accessing and Modifying the Value of a Cell: http://www.aspose.com/docs/display/cellsnet/Accessing+and+Modifying+the+Value+of+a+Cell

- Managing Comments in Worksheet: http://www.aspose.com/docs/display/cellsnet/Managing+Comments+in+Worksheet

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

- 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

- 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