Aspose.Cells for Java 8.9.2 Release Notes

1) Aspose.Cells

CELLSJAVA-41925Calculation time has increased with recent API revisionsNew Feature
CELLSJAVA-40958User configurable fonts substitution mechanism is requiredNew Feature
CELLSJAVA-41936Workbook.calculateFormula() method never terminates for the source Excel fileEnhancement
CELLSJAVA-41928Unable to catch image resource while rendering spreadsheet to HTML with IStreamProviderBug
CELLSJAVA-41841Problem with rendering CheckBoxes to HTMLBug
CELLSJAVA-41932Issue with getDisplayStringValue() for Date formatted valuesBug
CELLSJAVA-41930Using Light Cells APIs to process an XLS file, the first cell of the first sheet is always processedBug
CELLSJAVA-41931Character spacing and break not correct for vertical text while rendering spreadsheet to PDFBug
CELLSJAVA-41709Column widths are different on CentOS than on WindowsBug
CELLSJAVA-41933Chart scale has shifted while rendering spreadsheet to PDFBug
CELLSJAVA-41934Alignment problem when rendering an Excel file to PDFBug
CELLSJAVA-41935Formatting of legend entries is disturbed while rendering spreadsheet to PDFBug
CELLSJAVA-41943Horizontal axis labels have not been rendered completely, that is; all labels are missing some contents in the rendered image.Bug
CELLSJAVA-41940File is corrupted after formula calculation and saveBug
CELLSJAVA-41952Calculation result is not correctBug
CELLSJAVA-41941Array Formula is not being calculated properlyBug
CELLSJAVA-41937Some values from the Excel file are missing in the output HTML - XLS to HTML conversionBug
CELLSJAVA-41927Exception: “java.lang.OutOfMemoryError” while saving to HTML file formatException
CELLSJAVA-41945CellsException: Error in calculating Cell[0Sheet1!E5] at Workbook.CalculateFormula while calculating TREND functionException
CELLSJAVA-41946Opening excel file causes java.lang.NumberFormatException: For input string: “80000020”Exception
CELLSJAVA-41922IndexOutOfBoundsException while copying 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.

Adds CopyOptions.ReferToDestinationSheet property and Cells.CopyRows(Cells sourceCells, int sourceRowIndex, int destinationRowIndex, int rowNumber, CopyOptions copyOptions) method

Specifies whether to refer to destination worksheet (as a data source for the chart) while copying rows/range. When copying the range and the chart refers to the source sheet, False means the copied chart’s data source will not be changed. True means the copied chart’s data source refers to the destination sheet.

Adds HtmlSaveOptions.FilePathProvider property

Gets or sets the IFilePathProvider for exporting Worksheet to html separately.

Adds IFilePathProvider interface

Represents the exported file path provider.

Adds FontConfigs class

Specifies font settings.

Adds FontSourceBase class

This is an abstract base class for the classes that allow the user to specify various font sources.

Adds FileFontSource class

Represents the single TrueType font file stored in the file system.

Adds FolderFontSource class

Represents the folder that contains TrueType font files.

Adds MemoryFontSource class

Represents the single TrueType font file stored in memory.

Adds FontSourceType enum

Specifies the type of a font source.

Adds CalculationOptions.Recursive property

Specifies whether calculate the dependent cells recursively when calculating one cell and it depends on other cells.

Obsoletes CellsHelper.FontDir property

Use FontConfigs.SetFontFolder(string, bool) method with folder recursive to false instead.

Obsoletes CellsHelper.FontDirs property

Use FontConfigs.SetFontFolders(string[], bool) method with folder recursive to false instead.

Obsoletes CellsHelper.FontFiles property

Use FontConfigs.SetFontSources(FontSourceBase[]) instead.

Obsoletes Shape.LineFormat property and adds Shape.Line property

Please use Shape.Line property instead.

Obsoletes Shape.FillFormat property and adds Shape.Fill property

Please use Shape.Fill property instead.

Obsoletes ShapeFormat class and Shape.Format property

Please directly use Shape.Fill and Shape.Line properties.

Obsoletes ShapeFont class and adds TextOptions class

Please use TextOptions class instead.

Adds TextOptions.Fill property, TextOptions.Outline and TextOptions.Shadow property

Represents the fill, outline and shadow of the text.

Obsoletes FontSetting.ShapeFont property and adds FontSetting.TextOptions property

Please use FontSetting.TextOptions property instead.