Set Default Font for Rendering Spreadsheets to Image & HTML Format inside .NET Apps

2024-10-30 11:03:42 Computer

1233

We are pleased to announce the new release of Aspose.Cells for .NET 8.9.0. Aspose.Cells for .NET API has provided the ability to specify the default font name for rendering spreadsheets to image formats. The DefaultFont property is of type System.String with default value as null. The said property can be used when Unicode characters in the spreadsheet have not been formatted with appropriate font in the cell?s style, consequently such characters may appear as blocks in the resultant images. It is advised to set the DefaultFont property to MingLiu or MS Gothic to show Unicode characters. If the DefaultFont property is not set, Aspose.Cells for .NET API will use the system?s default font to show the Unicode characters. It has exposed the a new property for the HtmlSaveOptions class that allows to specify the default font name while rendering spreadsheets to HTML format. The default font will be used only when a particular font used to format some contents in the spreadsheet does not exist on the machine where conversion process has to take place. The default value of the property is null that means, the API will use the universal font which has the same family with the original font. Aspose.Cells for .NET API has exposed the Boolean type IsExcel2003Compatible property for the PivotTable class which allows to specify if a given PivotTable is Excel 2003 compatible for refreshing purposes. The default value of IsExcel2003Compatible property is true, that means a string must be less than or equal to 255 characters. If the string is greater than 255 characters, it will be truncated. If false, the aforementioned restriction will not be imposed. There are some important enhancements in this release, such as expanding text from right to left while exporting spreadsheets to HTML, get the Release or Running Version of Aspose.Cells.GridWeb and add or Remove Context Menu Items in Aspose.Cells.GridWeb. We have handled a few exceptions regarding reading and writing Excel and HTML file formats. We have also handled an exception when calling Autofit operation on a worksheet. In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel file formats, copying worksheets, manipulating PivotTables, adding List Objects/Tables, converting spreadsheets to HTML files and vice versa, manipulating and rendering charts and shapes, rendering images from Excel worksheets, 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

? Support expanding text from right to left when exporting file to HTML
? Ability to set Default Font while rendering spreadsheet to HTML
? Ability to set Default Font while rendering spreadsheet to images
? Refreshing Pivot Table throws exception
? Excel file is not properly rendering into HTML file format
? Contents overlap while converting spreadsheet to HTML
? Pivot Field's dropdown is missing after re-saving XLSX as XLSB
? Spreadsheet becomes corrupted after re-saving XLSX as XLSB
? Refreshing and Calculating Data on existing Pivot Table generates corrupt Excel file
? Chart.ToImage is generating incorrect image
? Some text items are slightly truncated in the output HTML
? Problem exporting Excel to PDF with special characters in the header and footer
? Vertical alignment wrong when generating range to image using SheetRender.ToImage
? Aspose.Cells generated EMF shows incorrect axis labels when inserted into Word document and converted to PDF
? Less than single spacing doesn't export to PDF properly
? Chart's EMF generated under Session 0 does not display all the contents
? Chart.HasAxis is showing wrong value
? Empty PNG 0KB file generated while converting XLSX to HTML
? Cells.ClearContents removes the formula for the cells below the specified range
? Issue with Worksheet.Copy() - All comments after IV column are missing in the copied sheet
? Pictures in worksheets copied from an external XLSX are not sized the same as originals
? Copying workbook into new workbook produced unreadable content error
? TextBox in the chart is lost while copying Workbooks
? Chart colors are lost while copying workbook
? Formula results in "#NAME" error after copying the rows and calculating formulas
? Formula is replaced by 0 after copying the rows and calculating formulas
? The fill format of shape is lost when converting the file to HTML
? Printing zone is moved a bit using latest versions of the product
? Showing total for list object with only 1 record corrupts the workbook
? Incorrect ListObject size after ShowTotals set to false
? Add/Remove context menu items in Aspose.Cells.GridWeb
? Support CellsHelper.GetVersion() API for GridWeb
? GridWeb control's height grows on scrolling down post back
? Scrollbar moves down on IE11 and sometimes GridWeb loses grid formatting

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.

- Set Default Font while rendering spreadsheet to images: http://www.aspose.com/docs/display/cellsnet/Set+Default+Font+while+rendering+spreadsheet+to+images

- Set Default Font while rendering spreadsheet to HTML: http://www.aspose.com/docs/display/cellsnet/Set+Default+Font+while+rendering+spreadsheet+to+HTML

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

- 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