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

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

Added: (Tue Jun 05 2018)

Pressbox (Press Release) - 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

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.

- Save Workbook to Strict Open XML Spreadsheet Format: https://docs.aspose.com/display/cellsnet/Save+Workbook+to+Strict+Open+XML+Spreadsheet+Format

- Specify Individual or Private Set of Fonts for Workbook Rendering: https://docs.aspose.com/display/cellsnet/Specify+Individual+or+Private+Set+of+Fonts+for+Workbook+Rendering

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
Phone: 888.277.6734
Fax: 866.810.9465

Submitted by:Aspose
Disclaimer: Pressbox disclaims any inaccuracies in the content contained in these releases. If you would like a release removed please send an email to remove@pressbox.co.uk together with the url of the release.