Save workbook in Strict Open XML Spreadsheet format and avail other enhancements in Aspose.Cells for .NET 18.5

Share on FacebookTweet about this on TwitterShare on LinkedIn


Aspose.Cells for .NET logo
We are pleased to announce the release of Aspose.Cells for .NET v18.5. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. In this release, we have added a few valuable features. We also included some important fixes and other enhancements for the users. Please check the release notes in order to get an idea about what is new and what has been enhanced or fixed with this revision of Aspose.Cells for .NET.

Save Workbook to Strict Open XML Spreadsheet Format

Aspose.Cells now allows you 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 you set its value as OoxmlCompliance.Iso29500_2008_Strict, then the output Excel file will be saved in Strict Open XML Spreadsheet format.

// Create workbook.
Workbook wb = new Workbook();
 
// Specify - Strict Open XML Spreadsheet - Format.
wb.Settings.Compliance = OoxmlCompliance.Iso29500_2008_Strict;
 
// Add message in cell B4 of first worksheet.
Cell b4 = wb.Worksheets[0].Cells["B4"];
b4.PutValue("This Excel file has Strict Open XML Spreadsheet format.");
 
// Save to output Excel file.
wb.Save("outputSaveWorkbookToStrictOpenXMLSpreadsheetFormat.xlsx", SaveFormat.Xlsx);

Please see the following article for more detail on this topic for your reference.

Specify Individual or Private Set of Fonts for Workbook Rendering

Generally, you specify the fonts directory or list of fonts for all the workbooks but sometime, you have to specify individual or private set of fonts for your desired workbooks. Aspose.Cells provides IndividualFontConfigs class that can be used to specify the individual or private set of fonts for your workbook. Please see the following article for more detail on this topic for your reference:

Specify the Far East and Latin Name of the Font in Text Options of Shape

Sometimes you 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, you can also specify the Latin font name using TextOptions.LatinName property. Please see the following article for more detail on this topic for your reference:

Other Enhancements and Fixes

There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements are as follows.

  • Aspose.Cells formula calculation engine is enhanced and we have added more advanced formulas/functions to the supported list.
  • Handled an exception “Invalid formula…” when refreshing pivot chart data.
  • Handled NullReferenceExceptions on opening MS Excel files on Mono Ubuntu Linux.
  • Handled an exception when using ListObject.ConvertToRange method.

In Aspose.Cells 18.5, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, manipulating PageSetup options, Smart Markers, manipulating ListObject/Tables, rendering and manipulating charts and shapes, manipulating PivotTables, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release.

Changes to the Public API

This version of Aspose.Cells for .NET has made some changes to the Public API. A few of the worth mentioning changes are as follow:

  • Added Cell.IsTableFormula/IsArrayFormula (new properties) to replace older Cell.IsInTable/IsInArray, it indicates whether one cell is part of the table formula or array formula.
  • Added IndividualFontConfigs class, it represents Font configs for each workbook object.
  • Added OoxmlCompliance enum and WorkbookSettings.Compliance property, it supports Strict Open Xml Spreadsheet.
  • Added GroupShape.Ungroup() method, it ungroups shapes.
  • Added MsoFormatPicture.Gamma property, it gets and sets the gamma of the picture.
  • Added TextOptions.FarEastName and TextOptions.LatinName properties, these attributes get and set the Far East and Latin name of the font.
  • Deleted obsoleted FontSetting.ShapeFont property.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks: