Release Unmanaged Resources of Workbook & Calculate Width/Height of Cell Value using .NET

We are pleased to announce the new release of Aspose.Cells for .NET 8.5.1. It provides methods for calculating the width & height of the cell value in the unit of pixels. These methods are useful in scenarios where application requirement is to set the width of the column and height of the row according to the size of cell value. Aspose.Cells APIs provide the ICustomFunction interface which can be used to implement the user defined or custom functions that are not supported by Microsoft Excel as built-in functions. While implementing the ICustomFunction interface, most of the times we require to return a single cell value however, sometimes we may also need to return a range of values. Aspose.Cells for .NET 8.5.1 has exposed the Workbook.Dispose() method to release the unmanaged resources of the Workbook object. The dispose pattern is used only for objects that access unmanaged resources, such as file and pipe handles, registry handles, wait handles, or pointers to blocks of unmanaged memory. This is because the garbage collector is very efficient at reclaiming unused managed objects, but it is unable to reclaim unmanaged objects. With this revision, the API has exposed the TableDataSourceType enumeration & readonly ListObject.DataSourceType property that can be used to detect the data source type of a ListObject. In the new version, we have also provided important enhancements such as Provided support to link to external workbooks in the desktop grid control provided by Aspose.Cells for .NET and Support Right-to-Left Display of Worksheets in desktop grid control provided by Aspose.Cells for .NET. We have handled some exceptions when reading/writing Excel spreadsheets and copying worksheets from other workbook. We have also fixed an exception in Shape to Image rendering. In this release, several important issues have been addressed. For example, issues around reading/ writing Microsoft Excel file formats, manipulating Pivot Tables, combining workbooks, setting conditional formatting, protecting workbooks, manipulating drawing objects and shapes, rendering images from Excel worksheets, manipulating charts with formatting, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have also enhanced the Aspose.Cells formula calculation engine and fixed a few issues in this regard. This release includes several enhanced features and bug fixes as listed below

? ICustomFunction - returning a range instead of a single cell
? Cell.GetHeightOfValue() similar to Cell.GetWidthOfValue() needed
? Link to external workbook creates #REF! in GridDesktop
? Right to Left Display
? PivotTable does not refresh when saving to PDF
? Pivot Table's Banded Rows option is lost
? Pivot Table doesn't keep sorting when combine
? Error message pops up after saving workbook
? Values are not correct when data changes
? Different value after CalculateFormula
? Workbook.CalculateFormula does not calculate correct values
? Calling the Worksheet.GetPrintingPageBreaks changes the TextBox width
? Cell.RemoveArrayFormula does not remove the array formula
? Excel syntax not supported for the formulas
? Aspose.Cells renders 2 pages
? Text is getting cutoff while rendering worksheet to EMF image
? Chart image doesn't contain the same values as the x axis from the excel chart
? Refreshing the PivotTable with new data changes the chart's color style
? Combining Workbooks change the Chart style
? Color of the picture looks differently after converting to PDF
? Contents and shapes are shifting when Excel is saved to PDF
? Excel shows Protected View on Aspose.Cells saved spreadsheet
? Cell.GetPrecedents() not returning correct worksheet name
? The background color of the conditionally formatted cells change
? Conditional format rules corrupted
? Inconsistent Workbook protection behavior
? Excel cannot open file after conversion from XLSM to XLS
? Combining Workbooks cause the Excel's "Cannot edit a PivotTable in group edit mode" warning

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.

- Calculate the Width and Height of the Cell Value in Unit of Pixels: http://www.aspose.com/docs/display/cellsnet/Calculate+the+Width+and+Height+of+the+Cell+Value+in+Unit+of+Pixels

- Release Unmanaged Resources of the Workbook: http://www.aspose.com/docs/display/cellsnet/Release+Unmanaged+Resources+of+the+Workbook

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

- 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

Company :-Aspose

User :- Sher Azam

Email :-sher.azam@aspose.com

Phone :-888-277-6734

Mobile:- -

Url :- http://www.aspose.com/blogs/aspose-products/aspose-cells-product-family/archive/2015/07/27/calculate-the-width-and-height-of-the-cell-value-and-get-an-array-of-values-from-icustomfunction-using-aspose.cells-for-.net-8.5.1.html