Aspose.Cells for Java 20.6 Release Notes

CELLSJAVA-43186Calculate the grand total for every row with expanded columnEnhancement
CELLSJAVA-43191Provide means to handle scenarios when specifying incorrect font typesEnhancement
CELLSJAVA-43187Exception when loading an XLS “Microsoft Excel 5.0 / 95 Workbook” files Enhancement
CELLSJAVA-43180HTML to Excel conversion creating black worksheet outputBug
CELLSJAVA-43181The difference in row height in converting Excel to HTMLBug
CELLSJAVA-43188The background color style is not being retained during HTML to excel conversionBug
CELLSJAVA-43196A different number of VBA modules detected using Aspose.Cells for Java 20.4 and 20.5Bug
CELLSJAVA-43202Resources not released on workbook creation completionBug
CELLSJAVA-43203Unable to process some Excel validation lists based on the named ranges with Unicode namesBug
CELLSJAVA-43185JPEG quality is always 75 on setImageResample on LinuxBug
CELLSJAVA-43192Load font folder /System/Library/Fonts on macOS by defaultBug
CELLSJAVA-43157Customized data series color is not preserved when creating a Waterfall chartBug
CELLSJAVA-43175An issue with chart series name when referencing workbook to other workbooksBug
CELLSJAVA-43201Exception “java.util.EmptyStackException” on saving to HTMLException
CELLSJAVA-43204NegativeArraySizeException occurs when using Cell.getDisplayStringValue()Exception
CELLSJAVA-43189Exception raised while loading the XLS fileException
CELLSJAVA-43193NullPointerException occurred when loading some XLSX filesException
CELLSJAVA-43200Exception “java.lang.ArrayIndexOutOfBoundsException” on loading the fileException

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 ReferredArea.GetValues(bool calculateFormulas)/GetValue(int rowOffset, int colOffset, bool calculateFormulas) method.

It gives the user the ability to control whether formulas should be calculated recursively in the implementation of AbstractCalculationEngine.

Adds WarningType.InvalidFontName and WarningType.InvalidTextOfDefinedName enum.

Represents the warning type.

Adds WarningInfo.CorrectedObject and WarningInfo.ErrorObject properties.

Represents the wrong data and updated data when a warning is thrown.

Adds WorkbookDesigner.RepeatFormulasWithSubtotal properties.

Indicates whether repeating formulas with subtotal rows.

Adds PlotArea.IsAutomaticSize property.

It indicates whether the size of the plot area is automatic.

Deletes obsoleted Style.Rotation property.

Use Style.RotationAngle property instead.

Adds Gridweb.SetFontFolder(string fontFolder, bool recursive)/SetFontFolders(string[] fontFolders, bool recursive) method.

Sets the fonts folder/folders