Save Workbook to Strict Open XML Spreadsheet Format & Enhanced Excel to PDF Rendering using .NET

What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 18.5. This release has added a few valuable features, important fixes and other enhancements. Aspose.Cells now allows users to save the workbook in Strict Open XML Spreadsheet format. This feature was demanded by certain users. This can be accomplished by Workbook.Settings.Compliance property. If users set its value as OoxmlCompliance.Iso29500_2008_Strict, then the output Excel file will be saved in Strict Open XML Spreadsheet format. Generally, users specify the fonts directory or list of fonts for all the workbooks but sometime, users have to specify individual or private set of fonts for a desired workbooks. Aspose.Cells provides IndividualFontConfigs class that can be used to specify the individual or private set of fonts for your workbook. Sometimes users want to display text in Far East language font e.g. Japanese, Chinese, Thai etc. Aspose.Cells provides TextOptions.FarEastName property that can be used to specify the font name of Far East language. Besides, users can also specify the Latin font name using TextOptions.LatinName property. There are some other enhancements included and a few exceptions handled in the new release for the users. This release includes several enhanced features and bug fixes as listed below

• Implement function CEILING.PRECISE
• Support Strict Open XML Spreadsheet format
• The color of the image should be black when converting to PDF
• Page Setup PrintErrorType not working in Excel to PDF rendering
• PageSetup.PrintDraft does not take effect while Saving to PDF
• System.OutOfMemoryException while converting Excel file to PDF
• Page field named "Absent item Yes" is lost on Refresh
• Calculation error when using calculation chain and defined name
• A few columns are disappeared when importing an Excel file into GridWeb
• Text wrapping is not correct when "Issue2 wrapping-no_custom_page_size.xlsx" is converted to PDF
• Text wrapping is not correct when "Issue2 wrapping.xlsx" is converted to PDF
• Text wrapping is not correct when "Issue3 wrapping.xlsx" is converted to PDF
• Page Setup zoom factor creates incorrect number of pages in PDF
• Exception when saving a workbook to MemoryStream
• Some of the Gridlines around some cells are not drawn correctly
• Chart title is squished where the characters all run together in Excel to PDF rendering
• Pie chart legend colors change after saving to PDF and do not match up with Pie chart slices
• Saving XLSB to XLSM creates corrupt MS Excel file
• Named ranges lost when copying into existing workbook
• Embedded drawing objects are too narrow in the output file when re-saving an XLSX file
• Aspose.Cells returns blank PDF when saving a SpreadsheetML file as PDF
• Data loss occurs while converting ODS to XLSX file format
• Named range does not expand with Smart Markers "shift" parameter
• Using "shift" parameter in Smart Markers, the generated rows are not rendered with the same style/formatting
• Conditional formatting does not work in Smart Markers with shift parameter
• Text cropped in MS Excel cells if the document rows are auto sized
• Resizing a ListObject/Table does not update its conditional formattings

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

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

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

This release was published on openPR.