Aspose.Cells for Java 20.12 Release Notes

CELLSJAVA-43367Support calculating ISFORMULA functionNew Feature
CELLSJAVA-43338Difference in output while converting Excel file to PDFBug
CELLSJAVA-43346Output file is corrupt when adding more than 12 fields in the pivot table page filtersBug
CELLSJAVA-43351Background colour of header table is not right while converting to pdfBug
CELLSJAVA-43358Text is missing while HTML to Excel conversionBug
CELLSJAVA-43341Extra empty columns while exporting CSV with LightCellsDataProviderBug
CELLSJAVA-43352Excel file converted to PDF produces an issue of large numbersBug
CELLSJAVA-43339Image is misplaced while converting source file to pdfBug
CELLSJAVA-43340Missing contents in XLS to PDF conversionBug
CELLSJAVA-43336Chart legend entries are rendered too far to the leftBug
CELLSJAVA-43356Empty values/gaps on a chart are not respected when in between 2 valuesBug
CELLSJAVA-43344Current User name is shown as author of last commentBug
CELLSJAVA-43349Hidden rows are not maintained from XML to XLS/XLSX conversionBug
CELLSJAVA-43361Incorrect cell color on xls to xlsx conversionBug
CELLSJAVA-43366SetAsTotal property does not updateBug
CELLSJAVA-43348XLSB to PDF conversion: CellsException: -2147483648Exception
CELLSJAVA-43343Exception when exporting a file to PDF that does not have a selected item for a shapeException

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 Cell.SetDynamicArrayFormula(string arrayFormula, FormulaParseOptions options, bool calculate) method.

Supports to set dynamic array formula and spill into neighboring cells if possible.

Adds Workbook.RefreshDynamicArrayFormulas(bool calculate) method.

Supports to refresh dynamic array formulas and spill into neighboring cells according to current data.

Adds Cell.Comment property.

Gets the comment of the cell.

Adds HtmlSaveOptions.ExportExtraHeadings property

Indicates whether exporting extra headings when the length of text is longer than max display column. The default value is false. If you want to import the html file to excel, please keep the default value.

Adds HtmlSaveOptions.ExportFormula property

Indicates whether exporting formula when saving file to html. The default value is true. If you want to import the output html to excel, please keep the default value.

Adds HtmlSaveOptions.MergeEmptyTdForcely property

Indicates whether merging empty TD element forcely when exporting file to html. The size of html file will be reduced significantly after setting value to true. The default value is false. If you want to import the html file to excel or export perfect grid lines when saving file to html, please keep the default value.

Adds LoadOptions.AutoFilter property

Indicates whether auto filtering the data when loading the files. Sometimes although autofilter is set, the corresponding rows is not hidden in the file.Now only works for SpreadSheetML file.

Adds WorkbookSettings.Author property

Gets and sets the author of the workbook.

Adds MultipleFilterCollection.Add() method.

Adds filter string of auto filter.