Aspose.Cells for Java 20.3 Release Notes

CELLSJAVA-43137Light Cells API: processing sheets in a specific orderNew Feature
CELLSJAVA-43135Remove ActiveXControl from Picture shapeNew Feature
CELLSJAVA-43141Add ThreadedComment.CreatedTime propertyNew Feature
CELLSJAVA-42068GIF in the worksheet is wrong when the workbook is converted into HTMLBug
CELLSJAVA-43127Excel Pivot Table is not automatically refreshed while the file first get open Bug
CELLSJAVA-43129Chinese text is garbled in HTML to XLS conversionBug
CELLSJAVA-43139The charts in the sheet are not refreshed when rendering worksheet to imageBug
CELLSJAVA-43148Chart label position errorBug
CELLSJAVA-43124On conversion to PDF two columns are cut off the tableBug
CELLSJAVA-43091Data labels on Donuts chart are overlapped in PDF fileBug
CELLSJAVA-43132Data labels missing from some charts while exporting chart to imageBug
CELLSJAVA-43143After WorkbookDesigner.process, Chart output null in HTMLBug
CELLSJAVA-43098Replacing embedded object with a picture does not work for XLS file formatBug
CELLSJAVA-43122An issue with Threaded comments’ order after import to Office365 XLSX file formatBug
CELLSJAVA-43134The string value of a cell is empty in Apple Numbers'09 Bug
CELLSJAVA-43144IsItalic property detected differently than MS Excel (Java)Bug
CELLSJAVA-43140IllegalArgumentException while calling calculateFormula()Exception
CELLSJAVA-43110Conversion to PDF - java.lang.NullPointerExceptionException

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.

Add property LoadFilter.SheetsInLoadingOrder

Users may override this property to specify the sheets and order to be loaded while importing workbooks from template files.

Deletes obsolete TickLabels.Background property

Use TickLabels.BackgroundMode property instead.

Obsoletes TickLabels.TextDirection property and adds TickLabels.ReadingOrder property

Use TickLabels.ReadingOrder property instead.

Obsoletes TickLabels.DirectionTypeproperty and adds enum ChartTextDirectionType

Represents the direction of text.

Adds Shape.RemoveActiveXControl() method.

Removes ActiveX data from the shape.

Adds ThreadedComment.CreatedTime property.

Gets and sets the created time of threaded comments.

Adds Worksheet.UniqueId property.

Gets and sets the unique id of the worksheet.

Adds enum IconSetType.ColorSmilies3 and IconSetType.Smilies3.

Represents the 3smiles icon set conditional formattings. Only for .ods file.s

Adds enum TimePeriodType.LastYear,TimePeriodType.NextYear and ThisYear.

Represents the last year, next year and this year conditional formattings. Only for .ods files.

Adds WorksheetCollection.RefreshPivotTables() method.

Refreshing all pivot tables in the file.