Create HTML with scalable column width and create custom filters with BeginsWith and EndsWith using Aspose.Cells for Java v18.10

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

It is announced with gratification that new updated version Aspose.Cells for Java v18.10 is released. As usual it contains lot of enhancements, bug fixes and new features as well. We put effort to greater extent to make our product easy to use and error free by working hard on all the issues which are reported by the vast developers community. Similarly 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. New features are always introduced for enhancing this product which helps us to compete the ever growing software industry. 

Release notes is an important document containing detailed overview of all the new features, bugs which are resolved in this version and list of enhancements as well.  Performance is always a major concern while working with third party tools, hence we take care of it as well like developers were facing little performance hit while working with conditional formatting. This issue is addressed and performance is improved as much as possible. You may go through the release notes to have a glimpse of all the changes in this new version. For more details about this product you may visit the links in the last section of this document. For an easy access and utilization, Aspose for Java APIs can be directly installed from Maven repository for which check document.
 

Scalable column width

Depiction of data through HTML page is very common, however this page can be opened in 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 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

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.

  • Convert left right ribbon shape to image
  • An exception(StackOverFlow) raises when saving to PDF output
  • Copy a range with PasteType.ALL (Paste options) not copying row heights properly
  • Invalid Russian date format output
  • Exception “java.lang.OutOfMemoryError: Java heap space” when rendering MS Excel file to PDF
  • Quotes appear in formula when retrieving the cell formula via Aspose.Cells
  • Performance degradation when using conditional formatting 

In Aspose.Cells 18.10, we fixed several important bugs and other issues. For example, wrong calculation done by ROUNDUP(), losing the hyperlink text formatting while setting the new text and resolving the issue pf fonts while rendering sheets with SheetRender.

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 Java Resources

The resources, you may need to accomplish your tasks:


To keep up with our news, you can follow us on Twitter or follow our Facebook page.