Configure Fonts for Rendering Spreadsheets & Control Chart’s Data Source Using Aspose.Cells for .NET 8.9.2

It provides the ability to configure Fonts for rendering spreadsheets. It also supports Recursive Calculation of Formulas, Control Chart’s Data Source while Copying Rows, Implement IFilePathProvider Interface and much more. It also includes some important fixes & enhancements, such as enter Cell Data of GridWeb Excel Worksheet in Percentage Format, enhanced HTML rendering engine, Improved PDF rendering engine for charts and shapes as well as style/formatting including cell’s text alignment.

Lane Cove, Australia, September 01, 2016 --( What is new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for .NET 8.9.2. This release includes several new features and other enhancements with critical bug fixes. Aspose.Cells API has exposed a number of new classes as well as an enumeration to configure font sources for rendering spreadsheets to image formats and PDF. Most important class is the FontConfigs which has many useful factory methods to either set the font sources or set the font substitution along with some inspection APIs to retrieve the list of specified font sources as well as font substitutions. Aspose.Cells APIs search the operating system’s default font directory for the required fonts. In case the required fonts are not available in the system’s font directory then the APIs search through the custom (user defined) directories. It also provides the ability to set user defined font substitutions for rendering purposes. This mechanism is helpful when a required font is not available on the machine where conversion has to take place. Users can provide a list of font names as alternative to the originally required font. In order to achieve this, the APIs have exposed a new method which accepts 2 parameters. The first parameter is of type string, which should be the name of font which needs to be substituted. The second parameter is an array of type string. Developers can provide a list of font names as substitution to original font (specified in the first parameter). The Aspose.Cells APIs has also provided means to gather information on what sources and substitutions have been set. Aspose.Cells for .NET API has exposed the Boolean type property along with the an overload of Cells.CopyRows method in order to facilitate the copy rows operation when rows to be copied also contains a chart and its data source. Users can make use of these new APIs to point the chart’s data source to the source or destination worksheets. This release allows to get/set the IFilePathProvider for exporting worksheets to separate HTML files. These new APIs are helpful in scenarios where hyperlinks in one worksheet points to a location in another worksheet, where application requirement is to render each worksheet to separate HTML file. Implementing the IFilePathProvider allows to keep the aforementioned hyperlinks intact regardless of the fact that they are pointing to a location in a separate resultant HTML file. It has made a few changes to the publicly exposed APIs in order to keep the API usage simple. This release has includes some important fixes and enhancements, such as enter Cell Data of GridWeb Worksheet in Percentage Format, enhanced HTML rendering engine, Improved PDF rendering engine for charts, shapes as well as style/formatting including cell’s text alignment and Tweaked Aspose.Cells’ formula calculation engine to match the results with Excel application. It has handled a few exceptions regarding reading and writing Excel and HTML file formats. In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel file formats, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. This release includes several enhanced features and bug fixes as listed below

• Support TTE font type while rendering spreadsheets to PDF
• Use private characters in PDF rendering
• Numbers formatting (DateTime) lost when importing data from DataGrid (.NET)
• Chart copied with CopyRows still reference the source worksheet in Chart Data Range
• Convert Date String to Date Format
• Colspan as 2 increases the HTML loading and conversion time drastically
• Performance degradation while rendering spreadsheets to PDF
• Bold attribute is lost while converting HTML to XLSX
• Direction of contents is changed while converting HTML to XLSX
• Borders are missing while converting HTML to XLSX
• Cell shading is missing while converting HTML to XLSX
• Contents are missing while converting HTML to XLSX
• Improper conversion of HTML to XLSX
• MHTML to XLS/XLSX is coming back as blank document
• Issue with hyperlinks referencing a worksheet in the same document

Other most recent bug fixes are also included in this release

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. Users 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. Users 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:

- Download Aspose.Cells for .NET:

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Phone: 888.277.6734
Fax: 866.810.9465
Sher Azam