Configure Fonts for Rendering Spreadsheets & Control Chart’s Data Source in .NET Apps

2024-11-02 05:19:45 Computer

1198

We are 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. You 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. You 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
? SumProduct formula is not calculated correctly
? Missed text after XLS to Pdf/A conversion
? Vertical alignment issue with cell content touching the top border while rendering spreadsheets to PDF
? Horizontal alignment issue with values preceded by $ sign while rendering spreadsheets to PDF
? Lost fonts in the PDF
? Result of CalculateTextSize is always the default height if text in a TextBox contains new lines
? Chart is not correct in the sample2.xlsx (Excel to PDF conversion)
? Data Tables are not correct in the sample2.xlsx (Excel to PDF conversion)
? Data Tables are not correct in the sample1.xlsx (Excel to PDF conversion)
? Modified radar chart marker does not convert to PDF properly
? Horizontal axis labels are missing in Chart to image rendering
? Issue with WordArt shape's formatting in the rendered PDF file
? Alignment is not working inside a TextBox
? File is corrupted (with hyperlink becomes normal text) after processed by Aspose.Cells APIs
? Re-embedding the presentation slide in XLS results in presentation view upon double clicking
? Excel error "Cannot start the source application for this object" after reinserting the OleObject of Bitmap type
? Formula results in #REF error after copying the rows and calculating formulas
? Date format not retained when saving as SpeadsheetML file
? Inserting range of cells causes background for some cells disappeared
? Path issue with external data links for XLS spreadsheets
? Resaving spreadsheet with custom theme causes error in Open XML SDK
? Custom Calculation Engine causes the calculation happen only once
? Error during opening an XLSB file
? Conversion from HTML to XLSX in the resultant spreadsheet
? Contents are missing while converting HTML to XLSX
? Style is missing while converting HTML to XLSX
? Impossible to make a TextBox fully transparent
? Chart.Calculate() method messes up the chart
? Series is missing while rendering chart to image
? Ambiguous comments for the depreciated Shape.LineFormat & FillFormat properties
? Default behaviour of adding TextBox to Worksheet has changed
? OLELink changed (Word table imported in Excel) document still shows old values after Update Links
? Colors are changed after loading and saving an XLS file
? Issue when using Percentage2 Number Format
? Vertical scroll bar appears for the container when height of the GridWeb is set to 100%
? Cursor is not moving when ShowCellEditBox is set true
? Merging cells second time is not working
? Problem setting the value of a cell with percentage format
? GridDesktop does not have evaluation limitations when used in WPF application
? Implement or add comment inside the acwmain.js file to know its version number
? Extra empty cell is inserted to the right of the first empty cell on pasting row

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.

- Configuring Fonts for Rendering Spreadsheets: http://www.aspose.com/docs/display/cellsnet/Configuring+Fonts+for+Rendering+Spreadsheets

- Enter Cell Data of GridWeb Worksheet in Percentage Format: http://www.aspose.com/docs/display/cellsnet/Enter+Cell+Data+of+GridWeb+Worksheet+in+Percentage+Format

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/products/cells/net

- Download Aspose.Cells for .NET: http://www.aspose.com/downloads/diagram/net

- 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/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465