Aspose.Cells for Java 17.9 Release Notes

Key Summary Category
CELLSJAVA-42391 Cell width shown in the resulted PDF is not the same as in the Excel file when using the “Show formula” feature New Feature 
CELLSJAVA-42379 Implement Named destination when rendering to PDF output (Bookmark query) New Feature
CELLSJAVA-42401 Have to enumerate all shapes to set the Z-Order of the shape properly Enhancement 
CELLSJAVA-42368 Set name of ActiveX Control (ListBox) Enhancement 
CELLSJAVA-42369 HTML output of Excel document contains hash values instead of actual values Bug 
CELLSJAVA-42366 Saving “2.2 CompleteEmail.html” to XLSX format generates corrupt file Bug 
CELLSJAVA-42365 Loading “2.1 CompleteEmail.html” in Workbook object throws NullPointerException Bug 
CELLSJAVA-42381 Workbook Calculation is wrong for Lookup Excel formula Bug 
CELLSJAVA-42380 Array formula in the sheet is calculated differently via Aspose.Cells Bug 
CELLSJAVA-42370 Incorrect Hyperlinks and PDF content Bug 
CELLSJAVA-42395 Rendering - Chart image is not correct Bug 
CELLSJAVA-42393 Category axis labels are missing when converting Excel to PDF  Bug 
CELLSJAVA-42384 Color of Negative Bars is not correct when Excel is converted to PDF  Bug 
CELLSJAVA-42378 Bar color changed while converting Excel to PDF when using setCrossAt() Bug 
CELLSJAVA-42377 Value of major units of axis in the chart is returned wrong Bug 
CELLSJAVA-42364 Datalabels from cell range are not coming when exported to PDF  Bug 
CELLSJAVA-42359 Missing Datalabels for a Series which is having Bar Values as 100 Bug 
CELLSJAVA-42314 Chart is blank in the output PNG Bug 
CELLSJAVA-42313 Chart is blank in the output PDF Bug 
CELLSJAVA-42374 Character references parsed incorrectly by Aspose Cells Bug 
CELLSJAVA-42373 Copying workbook and then saving corrupts the output Excel file Bug 
CELLSJAVA-42392 Exception “com.aspose.cells.CellsException: unknown excel content!” on instantiating an encrypted Excel file Exception 

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 HTMLLoadOptions.LoadStyleStrategy property

Indicates the strategy to apply style for parsed values when converting string value to number or DateTime.

Adds class AbstractCalculationMonitor

Provides APIs for users to monitor the progress of formula calculation.

Adds CalculationOptions.CalculationMonitor property

Allows user to provide custom implementation to monitor the progress of formula calculation.

Adds enum GridlineType

Enumerates gridline Type.

Adds ImageOrPrintOptions.GridlineType property

Gets or sets gridline type.

Adds PdfSaveOptions.GridlineType property

Gets or sets gridline type.

Adds Name.GetRanges(bool) and Name.GetRange(bool) methods

For simple Name objects mostly, such as, named ranges with absolute references, the name’s reference needs not to be calculated repeatedly. So GetRanges(false)/GetRange(false) will not re-calculate the Name object when getting corresponding range(s) and so the the performance may be improved significantly if those methods are called repeatedly.

Adds PdfBookmarkEntry.DestinationName property

Gets or sets name of destination. If desitnation name is set, the desitnation will be defined as a named destination with this name.

Adds DataSorter.AddKey() method

Adds sorted column index and sort order with custom sort list.

Adds Picture.Copy() method

Copies settings from other picture.

Adds Shape.ToFrontOrBack() method

Brings the shape to front or sends it to the back.

Adds enum ConnectionDataSourceType.Table

Represents the table as the data source of the connection.

Adds PageSetup.SetFitToPages() method

Sets the number of pages the worksheet will be scaled to when it’s printed.

Adds PdfSaveOptions.StreamProvider property and ResourceLoadingType enum

Gets and sets the type of loading external resource.

Adds VbaModuleCollection.AddDesignerStorage() and GetDesignerStorage() methods

Gets and sets the designer storage of the VBA project.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs: