Render HTML with scalable column width, create custom filters and get connection points from shapes using Aspose.Cells for .NET v18.10

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose.Cells for .NET logoWe are pleased to announce the release of Aspose.Cells for .NET v18.10, the MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly – is fully documented. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. We have added a few important features while keeping the product more stable and feature rich API. In this release, we have also added some useful enhancements and resolved a number of issues. Sometimes when some bug or issue is reported, that guides us to provide some new feature or enhancement thus making this product more user friendly and capable of solving complex problems in an easier way. Simple features which become quite handy while working with a complex product are added like providing last saved time property for keeping track of changes etc.

Please check the release notes which cover all the new features, enhancements and list of bugs which are resolved in this new version. New features are always introduced for enhancing this product which helps us to compete the ever growing software industry. Exceptions handling empowers the developers to keep control of the applications and assist users in a better way to continue using the application without any interruption. You will get an idea about what is new and what has been enhanced or fixed with this revision of Aspose.Cells for .NET


Scalable column width

Depiction of data through HTML page is very common, however this page can be opened in a variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in “pt” which works in many cases. However there can be case where this fixed size may not be required. For example, if container panel width is 600px where this HTML page is being displayed. In this case you may get horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation.

For a working example refer to the following article:

Support to handle self closing tags in HTML

Empty tags are very common while working with HTML like we can face <td></td> or simply <td/>. Earlier self closing tags were not supported however now this support is provided. Now you can load any HTML with self closing tags and convert it to Excel file.

For a working example refer to the following article:

Support for German locale in Named Range Formulae

Named regions can have English formulae and this file can be used in environments where  systems are configured to German locale. There is need to translate these English formulae completely to German language for correct usage in MS Excel configured for German language. This feature is fully functional and can be used without any extra coding.

For a working example along with a template file refer to the following article:

Custom filter with BeginsWith and EndsWith

MS Excel provides custom filters like filter rows which begins with and ends with some specific string. This feature is available in Aspose.Cells and demonstrated by providing working examples.

For a working example refer to the following article:

Get connection points from shapes 

Aspose.Cells provide rich features to manage shapes in the spreadsheet. Sometimes there is need to get the connection points of a shape for aligning or placing the shapes at appropriate place. For this purpose all the connection points are required. Following code can be used to get the list of connection points of a shape where Shape.GetConnectionPoints() function is used.

For a working example refer to the following article:

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.

In Aspose.Cells 18.10, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, applying data filtering, manipulating OLE Objects, reading/writing HTML files, manipulating List Objects/Tables, applying auto-fit rows/columns, formatting cells, Smart Markers, manipulating document properties, rendering and manipulating charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. The Aspose.Cells formula calculation engine is further improved too.

Changes to the Public API

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java:

  • Adds HtmlSaveOptions.WidthScalable property, Indicates whether using scalable unit to describe the column width when exporting file to HTML. The default value is false.
  • Adds WorkbookDesigner.UpdateEmptyStringAsNull property
    Indicates whether processing the empty string value as null.
  • Updates the returned value of DocumentProperty.ToDateTime() method, BuiltInDocumentPropertyCollection.CreatedTime, BuiltInDocumentPropertyCollection.LastPrinted and BuiltInDocumentPropertyCollection.LastSavedTime properties Returns the time in local timezone.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks: