Browse our Products

Aspose.Cells for Python via Java 22.5 Release Notes

CELLSJAVA-44554Enhance the LightCells model for setting formulasEnhancement
CELLSJAVA-44535implement focus cell with vertical/horizontal scroll bar auto scroll to suitable postionEnhancement
CELLSJAVA-44588Detect file format for stream with passwordEnhancement
CELLSJAVA-44481Issue with ThreadedComment.setCreatedTime() methodBug
CELLSJAVA-44483Sorting not working after grouping the rowsBug
CELLSJAVA-44522Double value to string gives tailing zero which is incorrect when comparing with ms excel’s resultBug
CELLSJAVA-44501search next issue for the file duohangduolie.zipBug
CELLSJAVA-44529implement search for freezepaneBug
CELLSJAVA-44530investigate the issue of setactivecell does not work sometimesBug
CELLSJAVA-44534Graphic in print area not exported in Excel to HTML conversionBug
CELLSJAVA-44539Chart is shifted to right while converting to html with print areaBug
CELLSJAVA-44568Multi-lines captions are lost except the first line in HTML to XLS conversionBug
CELLSJAVA-44512Chart is missing while exporting chart to svg in htmlBug
CELLSJAVA-44556Issue with data display in the data table after the coordinate axis is set to logarithmic scale - Excel to HTML/PDF conversionBug

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.

Changes for saving Workbook with LightCells

To make formula-related features available for LightCells, in old versions we keep all formula data in cells model in memory when saving workbook with LightCells. This caused misunderstanding and misuse of LightCells for some users. User had thought that cell’s formula data has been released out of the scope of StartCell(Cell) but in fact not. For most users that use LightCells, their primary concern is performance(memory cost). Few people will use formula-related functions other than setting simple formula to the cell in the process of saving Workbook. So, from this version we add some restrictions for changing the cell object in the scope of StartCell(Cell) method. Now it is not allowed to set shared formulas, array formulas for the given cell object in StartCell(Cell) method. If such kind of formulas are needed, user should set them before saving workbook. With this change, we improved the performance for most users that need to save simple formula for cells to the resultant spreadsheet file with LightCells.

Deletes obsolete method Cell.SetAddInFormula()

Please use WorksheetCollection.RegisterAddInFunction() and Cell.Formula/Cell.SetFormula() instead.

Adds ExceptionType.FileCorrupted enum

Represents the type of exception is the file is corrupted.

Adds WarningType.Limitation enum

Represents the warning type is the limitation of Excel.

Adds ShapeGuideCollection.Add(string name, double val) method.

Adds a shape guide.