Aspose.Cells for Java 17.5 Release Notes

CELLSJAVA-41130Change the language of the predefined words for Pivot TableEnhancement 
CELLSJAVA-42272Options to embed the hyperlink in an Excel cellEnhancement 
CELLSJAVA-42283NullPointerException occurs when the filter exists outside of the named rangeBug
CELLSJAVA-42282Copying a worksheet unhides filtered rows in the output HTML fileBug 
CELLSJAVA-42276Contents are shown differently (some text is missing) in non IE browsers (e.g Google chrome) - Excel to HTML renderingBug 
CELLSJAVA-42247Conditional formatting is lost when refreshing PivotTable in the spreadsheetBug 
CELLSJAVA-42257Conditional formatting style is brokenBug 
CELLSJAVA-42202Excel formula is not working properly - it is shown as 6 instead of 0Bug 
CELLSJAVA-42286Saving XLS file with graphs uses 100% CPUBug 
CELLSJAVA-42251Title is obscured by the trend labels in the output PDF Bug 
CELLSJAVA-42284Workbook.getFonts() shows additional fonts after reload the same spreadsheetBug 
CELLSJAVA-42281Merging/Copying to Excel sheets - Spaces in the beginning of the cells are not getting retainedBug 
CELLSJAVA-42280Invalid string in the file - error occurs on opening an Excel fileBug 
CELLSJAVA-42275Names of some public methods parameters changed in the newer versionBug 
CELLSJAVA-42271Worksheet.autoFitColumns() does not work well with the cells having line breaksBug 
CELLSJAVA-42266Sorting the Excel file containing comments corrupts the output Excel fileBug 
CELLSJAVA-42265Sorting comments causes “Excel found unreadable content….” error when opening the output file into MS ExcelBug 
CELLSJAVA-42264Subscript and superscript issues in OpenOffice ODS file when converting to HTML or PDFBug 
CELLSJAVA-42268Exception: “java.lang.NullPointerException” when rendering a chart to imageException 
CELLSJAVA-42278Exception: “java.lang.IndexOutOfBoundsException: Index: 12, Size: 12” when saving to HTML file formatException 
CELLSJAVA-42274Exception: “java.lang.StringIndexOutOfBoundsException: String index out of range: 0” when loading an XLSX 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 ExportTableOptions.ExportAsHtmlString property

Exports the HTML string value of the cells to the DataTable.

Adds PageSetup.Copy(PageSetup source,CopyOptions copyOptions) method

Copies the settings of the Page Setup.

Adds ImportTableOptions.ShiftFirstRowDown property

Indicates whether shifting the first row down when inserting table.

Adds PageSetup.CustomPaperSize() method

Sets the custom paper size, in the unit of inches.

Adds PageSetup.PrinterSettings property

Gets and sets the settings of the default printer.

Adds constants PaperSizeType.CUSTOM

Represents the custom paper size.

Adds constants PdfCompliance.PDF_A_1_A

Represents PDF format compatible with PDFA-1a.

Usage Examples

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