Aspose.Cells for Java 18.2 Release Notes

Key Summary Category
CELLSJAVA-42509 Add LoadDataFilterOptions.NAMES constant to filter defined names when loading workbook New Feature 
CELLSJAVA-42510 Observe very slow filtering in Microsoft Excel 2013 and 2016 when filter is applied Enhancement 
CELLSJAVA-42497 Sheet1 shapes are lost and Stars in Sheet2 are rounded Bug 
CELLSJAVA-42512 Invalid encoding - Exception occurs on loading the Excel file Bug 
CELLSJAVA-42507 Macro and Dialog sheets are detected as regular worksheets Bug 
CELLSJAVA-42503 MS Excel does not allow to save XLS file again Bug 
CELLSJAVA-42502 Aspose.Cells is not filtering data correctly instead it hides all the rows Bug 

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.