Aspose.Cells for Python via Java 22.6 Release Notes

KeySummaryCategory
CELLSJAVA-44632Supports formatting the entire row of data in the PivotTableNew Feature
CELLSJAVA-44611Improvement for reading blank cells from xlsx fileEnhancement
CELLSJAVA-44616Original settings of conditional formatting in the range of destination should be removed when copying rangeEnhancement
CELLSJAVA-44658Support BouncyCastle v1.71Enhancement
CELLSJAVA-44628How to retain percentage format of certain pivot rows when expanding node data of a pivot column/fieldBug
CELLSJAVA-44483Sorting not working after grouping the rowsBug
CELLSJAVA-44609Slow copy with conditional formatting using newer versionBug
CELLSJAVA-44622When sorting large groups with multiple keys, it throws “java.lang.ArrayIndexOutOfBoundsException”Bug
CELLSJAVA-44630Issue with Smart Markers feature since Aspose Cells 22.5Bug
CELLSJAVA-44646Clear content on copied sheet throws NullPointerExceptionBug
CELLSJAVA-44656Cells.getMaxDataColumn returning different (wrong) value in 22.5Bug
CELLSJAVA-44650Excel document page is messy when loading into Aspose.Cells.GridWeb(Java)Bug
CELLSJAVA-44660Issue with data alignment when loading the XLS into Aspose.Cells.GridWeb (Java)Bug
CELLSJAVA-44661Issue when loading the et file into Aspose.Cells.GridWeb (Java)Bug
CELLSJAVA-44584The title of the axis in the chart is rotated in the output image - Chart to image conversionBug
CELLSJAVA-44615Gray line drawn in the output image from XLS fileBug
CELLSJAVA-44665Loading ODS file hangsBug
CELLSJAVA-44651“Not a numeric value” error when converting Excel sheet to HTML/PDFException

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 CellsDataTableFactory class

This class provides apis to create instance of ICellsDataTable from custom objects for user’s convenience.

Adds Workbook.CellsDataTableFactory property

Provide user the CellsDataTableFactory for creating instance of ICellsDataTable from custom objects.

Adds Cell.GetDependentsInCalculation(bool) method

According to current calculation chain, get all cells whose calculated result depends on this cell.

Adds Cell.GetPrecedentsInCalculation() method

According to current calculation chain, get all precedents(reference to cells in current workbook) used by this cell’s formula while calculating it.

Obsoletes Cell.GetLeafs() and Cell.GetLeafs(bool) methods

Please use Cell.GetDependentsInCalculation(bool) method instead.

Adds PivotTable.FormatRow(int row, Style style) method

Format the row data in the pivottable area.

Adds Shapes.CreateId property

Gets creating id of the shape.

Adds WarningType.InvalidData enum

Represents the invalid data type.

Adds overload ChartCollection.Add() method

Adds a chart with data source.

Adds Chart.GetActualSize() method

Gets actual size of chart in unit of pixels.

Obsoletes Chart.ActualChartSize property

Please use Chart.GetActualSize() method instead.

Obsoletes PdfSaveOptions.ImageType property

Chart and Shape are always rendered as vector elements(e.g. point, line) for rendering quality.

Obsoletes ImageOrPrintOptions.ChartImageType property

Chart and Shape are always rendered as vector elements(e.g. point, line) for rendering quality.

Deletes obsolete property ImageOrPrintOptions.ImageFormat property

Please Use ImageOrPrintOptions.ImageType property instead.

Deletes obsolete property ImageOrPrintOptions.IsImageFitToPage property

The property is useless.