Browse our Products

Aspose.Cells for PHP via Java 24.10 Release Notes

KeySummaryCategory
CELLSJAVA-46000Ignore row data in disorder when reading OOXML template filesEnhancement
CELLSJAVA-46130Support formatting date as 1900-2-29 to mimic ms excel’s behaviorEnhancement
CELLSJAVA-46118XLSX to PDF: Incorrect placement of flowchart arrows in the output PDF fileBug
CELLSJAVA-46079The result file shows inconsistency with Excel when converting the file to PDFBug
CELLSJAVA-46129The aspose-cells.jar may cause Eclipse show compile errorBug
CELLSJAVA-46133Precision issue of calculating formulas for JDK8 and later versions when FormulaSettings.PrecisionAsDisplayed is trueBug
CELLSJAVA-46119Waterfall chart labels do not retain original text color when resaving fileBug
CELLSJAVA-46125XLSX to PDF: Image is missing in the output PDF fileBug
CELLSJAVA-46107Inconsistent HTML output with excel file when saving to htmlBug
CELLSJAVA-46123Invalid backgroud color of td when converting to htmlBug
CELLSJAVA-46122The title of value field is not total in report pivot table.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.

Changes some behaviors of Cells.DeleteBlankRows()/Cells.DeleteBlankColumns().

In old versions, those two methods have different behaviors for drawing objects: when deleting rows, those objects will not be checked and may be deleted together with blank rows. When deleting columns, those objects will be checked and columns under them will not be taken as blank. Starting from 24.10, we have unified the behavior of those two methods and by default we do not check drawing objects. If user needs to keep those objects and corresponding rows/columns, please use DeleteBlankOptions with false value for DrawingsAsBlank property. And for such kind of situation, with old versions, user’s code may be simply like:

cells.deleteBlankColumns();

with new versions, please use code like:

DeleteBlankOptions options = new DeleteBlankOptions();
options.setDrawingsAsBlank(false);
cells.deleteBlankColumns(options);

Changes some behaviors of PivotTable.RefreshData().

In the old versions, an Exception is thrown when refreshing pivot table with external data source. We change it to return refreshing state to avoid breaking programs.

Adds method Cell.SetFormula(string formula, FormulaParseOptions options).

Sets specified formula for one cell, with user specified options for parsing formula.

Adds property DeleteBlankOptions.DrawingsAsBlank.

Indicates whether drawing related objects such as pictures, shapes, charts… should be taken as blank when deleting blank rows and columns.

Adds property DeleteBlankOptions.StartIndex/EndIndex.

Specifies the row/column range to check and delete blank rows/columns.

Obsoletes ExternalConnection.ConnectionId property.

Use ExternalConnection.Id property instead.

Adds ExternalConnection.ClassType property.

Represents the class type of external connection.

Adds ExternalConnection.SourceType property and obsoletes ExternalConnection.Type property.

Gets or Sets the external connection DataSource type.

Adds ExternalConnection.ConnectionFile property.

Gets the file name of external connection.

Adds ExternalConnection.Command property.

Gets the Command text of external connection.

Adds ExternalConnection.CommandType property.

Gets the Command type of external connection.

Adds ExternalConnection.ConnectionString property.

Gets the connection string of external connection.

Adds ExternalConnection.SecondCommand property.

Gets the second command of external connection.

Adds OdsLoadOptions.IsClassicPivotTable property.

Indicates whether loading pivot table of ods file as classic pivot table of Excel 97-2003.

Adds OdsSaveOptions.IgnorePivotTables property.

Indicates whether saving pivot tables to ods file.

Adds PivotRefreshState class.

Represents result state of refreshing pivot table.

Adds overload PivotTableCollection.Add(String,Int32,Int32,String,Boolean,Boolean) method.

Supports adding classic and compact pivot table.

Obsoletes PivotTable.ExternalConnectionDataSource property and adds PivotTable.GetSourceDataConnections() method.

Use PivotTable.GetSourceDataConnections() instead.

Adds PivotTable.GetNamesOfSourceDataConnections() method.

Gets the external connection data sources of pivot table.

Obsoletes PivotTable.ItemPrintTitles property and adds PivotTable.RepeatItemsOnEachPrintedPage property.

Use PivotTable.RepeatItemsOnEachPrintedPage instead.

Adds FileFormatType.Chm and LoadFormat.Chm enum.

Represents a CHM file.