We are back with pleasure to present another enhanced version Aspose.Cells for Java v18.9 containing a lot of new features, enhancements, and bug fixes as usual. These new features will strengthen our developer’s community to enhance their solutions and provide more advanced level products to their customers. We always prefer resolving the bugs which are reported by our precious developers to avoid missing any milestone in their development lifecycles and make the customers happy by providing bug-free products. Enhancements are another direction that we always follow to enrich our existing features and increase usability.

The detailed release notes are provided which cover all the new features, enhancements and list of bugs that are resolved in this new version. 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 interruptions. We have resolved many exceptions to achieve this goal. For easy access and utilization, Aspose for Java APIs can be directly installed from Maven repository for which check this document.

Export Custom Document Properties in Excel to PDF

Many documents can have custom properties that were not made part of the PDFs earlier. Now we have provided this feature to maintain the precious information through custom properties by exporting them to the PDF files. These properties can be observed in Adobe Acrobat Reader by clicking on File and then Custom tab page in the properties sheet.

For a working example refer to the following article:

Create Safe Sheet Names in Excel using C#

Sometimes there is a need for assigning the sheet name at runtime. In this scenario, there may be sheet names that may contain some additional characters like <>+(?”. There is a need to replace any such character, which is not allowed as a sheet name with some preset character provided by the user. Similarly, the length may increase to more than 31 characters which need to be truncated. Apache POI provides certain features of creating safe names, hence similar feature is provided by Aspose.Cells to handle all these issues.

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

Get XML Path from List Object/Table

XML data can be imported to worksheets where sometimes the XML path is required from the ListObjects of the worksheet. This feature is available in Excel by using an expression like Sheet1.ListObjects(1).XmlMap.DataBinding. We are glad to share that this feature is available now in Aspose.Cells as well.

For a working example refer to the following article:

Enhanced filters like Contains, Not Contains, Blank and Non-Blank

We have increased the range of auto filters like filtering based on fill color, date, dynamic date, number, and texts. These filters were already part of our previous releases. The need was felt to add filters like blank/non-blank and custom filters with contains and not-contains. This time these filters are added along with sample files so that these features can be tested easily.

For a working example refer to the following article:

Retrieve Query Table Result Range

QueryTable represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft access database. Aspose.Cells provides an option to read the address i.e. result range of cells for a query table.

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.

  • Chart in PDF is not generating from the Excel template
  • Duplicate legend item text in the chart in Excel to PDF conversion
  • Waterfall chart not rendered properly after changing the chart data
  • Wrong value retrieved for border style
  • Wrong bottom border style returned for merged cell
  • Gray borders appear after reading cell style in the worksheet
  • PasteType.VALUES_AND_NUMBER_FORMATS is not working fine
  • Exception: “FormulaBuildUnknown formula token0” on Name.getRefersTo()
  • Chart.calculate method causes OutOfMemoryError

In Aspose.Cells 18.9, we fixed several important bugs and other issues. For example, issues of not showing chart table in converted PDF, Issues in Cells.deleteRow() not displaying charts while converting ODS to PDF and error by MS Excel while loading file after setting autofilters.

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 **CellsHelper.CreateSafeSheetName(string nameProposal)/CreateSafeSheetName(string nameProposal, char replaceChar) methods **,Methods for user’s convenience to create valid sheet name
  • Adds **Row.FirstDataCell, **Gets the first non-blank cell in the row.
  • Adds **MapChartLabelLayout enum, **Represents the label layout type of the map chart
  • Adds MapChartProjectionType enum, Represents the projection type of the map chart
  • Adds MapChartRegionType enum, Represents the region type of the map chart
  • Adds QuartileCalculationType enum, Represents the quartile calculation type of the chart
  • Adds Series.LayoutProperties property and class SeriesLayoutProperties, Represents the layout properties of the series
  • Adds TickLabels.IsAutomaticRotation property, Indicates whether the rotation of the tick labels is automatic
  • Adds FilterOperatorType.BeginsWith, Contains, EndsWith and NotContains enum, Represents the text filter operator type
  • Adds Cell.GetDisplayStyle(bool) method, Gets the display style of the cell
  • Adds GlobalizationSettings.GetStandardHeaderFooterFontStyleName(string localFontStyleName) method, Gets standard English font style name (Regular, Bold, Italic) for Header/Footer according to given locale font style name
  • Adds PdfCustomPropertiesExport enum, Specifies the way CustomDocumentPropertyCollection are exported to PDF file
  • Adds PdfSaveOptions.CustomPropertiesExport property, Gets or sets a value determining the way CustomDocumentPropertyCollection are exported to PDF file. The default value is None
  • Adds class XmlDataBinding, Represents XML Data Binding information
  • Adds ListObject.XmlMap property, Gets an XmlMap used for this list
  • Adds XmlDataBinding.Url property, Gets source URL of this data binding
  • Adds XmlMap.DataBinding property, Gets an XmlDataBinding of this map

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks: