Aspose.Cells for Java 20.7 Release Notes

CELLSJAVA-43221Exception “java.lang.NullPointerException” when loading XLT fileEnhancement
CELLSJAVA-43222Exception “com.aspose.cells.CellsException: formula data should have been corrupted….” when loading an XLS fileEnhancement
CELLSJAVA-43223Exception “java.lang.IllegalStateException: Invalid encoding: null” when loading an XLS fileEnhancement
CELLSJAVA-43226Exception “java.lang.ArrayIndexOutOfBoundsException” when retrieving picture’s dataEnhancement
CELLSJAVA-43234Data before 2014 is not read from the Pivot TableBug
CELLSJAVA-43210Wrong value #Value read by Aspose.CellsBug
CELLSJAVA-43215Unable to transform XLSM file to PDFBug
CELLSJAVA-43219Adding formula reference to different sheet results in corrupted Excel workbookBug
CELLSJAVA-43232ROUNDUP function issueBug
CELLSJAVA-43243The formula could not be retrieved while changing the formula of the neighboring cellBug
CELLSJAVA-43217Printing XLSX to XPS loses background formattingBug
CELLSJAVA-43224Issue while printing to a physical printerBug
CELLSJAVA-43241Problem with Line Height and Border while creating an image from the Excel areaBug
CELLSJAVA-43209setRepeatFormulaWithSubtotal(true) not generating expected results while using SmartMarkersBug
CELLSJAVA-43213Aspose.Cells 20.6 is not working fine with form controls on Office 365 (version 2005 Build 12827.20268)Bug
CELLSJAVA-43214When translating XLS to XLSX, it produces a broken XLSX fileBug
CELLSJAVA-43216XLS to XLSX conversion - font boldness and positioning is changed for the shapeBug
CELLSJAVA-43228Generated XLS is in protected viewBug
CELLSJAVA-43231Error in the output file after replacementsBug
CELLSJAVA-43225Exception “java.lang.NullPointerException” when retrieving string value from the cellException
CELLSJAVA-43229Exception while loading XLSM file with option setKeepUnparsedData(false)Exception
CELLSJAVA-43238Calculation fails with NPE (java.lang.NullPointerException)Exception
CELLSJAVA-43199Exception “java.lang.NegativeArraySizeException” on saving to HTMLException

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 Cells.RemoveDuplicates() method.

Overloaded method of Cells.RemoveDuplicates(…) for user’s convenience to remove duplicated rows in the whole sheet.

Adds TickLabels.DisplayNumberFormat property.

Gets and sets the display number format of tick labels.

Adds Cells.GetViewRowHeight() and Cells.GetViewRowHeightInch() method.

Gets the view row height.

Adds enum SheetType.InternationalMacro.

Adds new sheet type: international macro.

Adds PivotFieldCollection.iterator() method.

Gets an enumerator over the elements in this collection in the proper sequence.

Adds PivotItemCollection.iterator() method.

Gets an enumerator over the elements in this collection in the proper sequence.

Adds Workbook.IsWorkbookProtectedWithPassword property.

Indicates whether the structure and window is protected with a password.

Add PowerQueryFormulaParameters and PowerQueryFormulaParameter classes

Represents the power query formula parameters.