Aspose.Cells for Java 19.3 Release Notes

KeySummaryCategory
CELLSJAVA-42845Keep separators for empty rows when exporting an XLS file to CSVNew Feature
CELLSJAVA-42846Text extraction results differ from the originalEnhancement
CELLSJAVA-42844The text is not properly aligned in PDF outputBug
CELLSJAVA-42834Text color (black) is changed to red in HTML renderingBug
CELLSJAVA-42839Scatter chart is not rendered in Excel to PDF conversionBug
CELLSJAVA-42840Horizontal axis labels are not rendered fine for charts in Excel to PDF renderingBug
CELLSJAVA-428422D Bubble chart is not rendered in Excel to PDF conversionBug
CELLSJAVA-42833Issue while embedding same PDF file in multiple sheets in a workbookBug
CELLSJAVA-42836Workbook.hasExernalLinks() does not return true for DDE linksBug
CELLSJAVA-42848Fonts setting and other objects not copied using Range.copy() functionBug
CELLSJAVA-42849IndexOutOfBoundsException exception while converting XLSX to HTMLException
CELLSJAVA-42831Exception raised by MS Excel after applying styling to range of header cellsException

Public API and Backwards Incompatible Changes

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. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Changes for default font of loaded XLS template file

In older versions, we did not support to apply the font defined in theme (advanced feature in MS Excel 2007 and later versions) according to the region when loading the XLS template files. On some users’ requirement, we have supported it from v19.3. If the region has been specified in the XLS template file, then we will apply the font defined in theme according to the saved specified region value. Otherwise we will apply the font defined in theme according to the application environment’s regional settings. This will cause the default font of the workbook (loaded from XLS template file which has specified theme data) changed, and then influence other features, such as column width, shape size, rendering effect, …etc.

Adds Name.GetReferredAreas(bool recalculate) method

Provides the references referred by the defined Name like GetRanges(bool recalculate) method. But the returned references are represented by ReferredArea object which provides richer features including external links.

Adds TxtSaveOptions.KeepSeparatorsForBlankRow property

Indicates whether separators should be output for blank row. Default value is false which means the content for blank row will be empty.

Adds enum AutoFitMergedCellsType

Represents the type of auto fitting merged cells.

Obsoletes AutoFitterOptions.AutoFitMergedCells property and Adds AutoFitterOptions.AutoFitMergedCellsType property

Gets and sets the type of auto fitting row height.

Adds JSONUtility and JsonLayoutOptions classes

It’s used to import json files.

Adds TableToRangeOptions class and ListObject.ConvertToRange(TableToRangeOptions options) method

Converts the table to range with options.