Aspose.Cells for Java 17.9 Release Notes

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

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: