Browse our Products

Aspose.Cells for Java 18.2 Release Notes

CELLSJAVA-42509Add LoadDataFilterOptions.NAMES constant to filter defined names when loading workbookNew Feature 
CELLSJAVA-42510Observe very slow filtering in Microsoft Excel 2013 and 2016 when filter is appliedEnhancement 
CELLSJAVA-42497Sheet1 shapes are lost and Stars in Sheet2 are roundedBug 
CELLSJAVA-42512Invalid encoding - Exception occurs on loading the Excel fileBug 
CELLSJAVA-42507Macro and Dialog sheets are detected as regular worksheetsBug 
CELLSJAVA-42503MS Excel does not allow to save XLS file againBug 
CELLSJAVA-42502Aspose.Cells is not filtering data correctly instead it hides all the rowsBug 

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 LoadDataFilterOptions.DefinedNames enum

Indicates whether loading defined Name objects when loading template file.

Changes the behavior of LoadDataFilterOptions.Formula enum

In older versions we always load defined Name objects when loading formulas. Now we provide separate enum for defined Name objects explicitly, so Formula enum will only denote that formulas should be loaded now, no matter the defined Name objects will be loaded or not. However, one thing should be noted, commonly defined Name objects are used by formulas, if user only loads formulas and does not load the defined Name objects, the cell formula which refers to those Names will become corrupted and may cause Exception. So, generally if user wants to load formulas, the defined Name objects should be loaded too. But user can load only defined Name objects without loading formulas.

Add SheetType.Dialog enum

Represents dialog sheet.

Adds WorkbookSettings.MaxRowsOfSharedFormula property

Gets and sets the max row number of shared formula. The shared formula will be split to several shared formula if the total rows of shared formula is greater than it.

Adds WorkbookSettings.StreamProvider property

Gets and sets the stream provider for external resource.

Adds ShapeTextAlignment.IsAutoMargin property

Indicates whether the margin of the text frame is atuomatic.

Adds ImportTableOptions.IsFormulas property

Represents which column in the datatable should be imported as formulas.