Aspose.Cells for Java 22.7 Release Notes

CELLSJAVA-44721Support sorting PivotField via calculated fieldNew Feature
CELLSJAVA-44733Investigate rules of ms excel to display cell’s border when adjacent column is hidden: cell’s border has not been synchronizedEnhancement
CELLSJAVA-44695Bad conversion to PDF from XLS with Line Callout at the left of the sheetBug
CELLSJAVA-44700Pivot table calculated fields not getting refreshed on updating data sourceBug
CELLSJAVA-44705Cell.getDependents() throws Exception or cannot provide all dependentsBug
CELLSJAVA-44717Issue with border (line) styleBug
CELLSJAVA-44707border line does not displayBug
CELLSJAVA-44670Issue with Formulas in the output HTML - Excel to HTML conversionBug
CELLSJAVA-44202When exporting to HTML, the legend in the chart is not the same as MS ExcelBug
CELLSJAVA-44591Text rotation of labels does not match with Excel in the output image of the chartBug
CELLSJAVA-44655Unable to display Treemap chart with negative value causing execution to keep runningBug
CELLSJAVA-44686The title text of chart(2016) is incorrect when Title.IsAutoText is trueBug
CELLSJAVA-44689Regression: Waterfall chart legend language issueBug
CELLSJAVA-44687Chart issue during combining filesBug
CELLSJAVA-44736Table styling lost when copying sheetBug
CELLSJAVA-44725Exception “ invalid entry size (expected 0 but got 1053 bytes)” while converting XLSX to 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 Cells.GetDependentsInCalculation(int,int,bool) method

Gets all cells whose calculated result depends on the cell specified by row and column according to current calculation chain. For the cell which is empty and has not been instantiated in current cells model, user may use this method instead of Cell.GetDependentsInCalculation(bool) because the later one needs to instantiate the cell object into current cells model at first.

Changes cell’s Left/Right border for Cell.GetStyle() when the adjacent column is hidden

In old versions, if the adjacent column is hidden for one cell, then this cell’s Left/Right border will not be checked with the adjacent cell, so the returned border may be different from what shown in ms excel’s dialog when setting this cell’s border. From 22.7, we make the returned border always be the actual value(which should be consistent with the border of its adjacent cell) of the cell for Cell.GetStyle(). If user needs what shown for the cell in ms excel(when the adjacent column is hidden, the shown border may be the one of next visible column), user may try Cell.GetDisplayStyle().

Add Range.Top, Range.Left, Range.Height and Range.Width properties.

Gets the position and size of the range in unit of points.

Delete class PowerQueryFormulaCollction and add class PowerQueryFormulaCollection class.

There is a typo in the old class.

Add HtmlSaveOptions.ExportPageFooters and HtmlSaveOptions.ExportPageHeaders properties.

Indicates whether exporting headers and footers when saving as a single html file.

Adds HtmlSaveOptions.ShowAllSheets property.

Indicates whether showing all sheets when saving as a single html file.

Obsoletes HtmlSaveOptions.ExportHeadings property and add HtmlSaveOptions.ExportRowColumnHeadings property.

Please use HtmlSaveOptions.ExportRowColumnHeadings instead.

Obsoletes Chart.ToImage(string, ImageFormat) and add Chart.ToImage(string, ImageType)

Please use Chart.ToImage(string, ImageType) instead.