Aspose.Cells for Java 20.1 Release Notes

CELLSJAVA-41325Cell.getValidation method returns null for ODSNew Feature
CELLSJAVA-43074XLSX to PDF, Difference in PDF output when using Oracle JDK vs Open JDKEnhancement
CELLSJAVA-43083Opacity is not being applied to column chartsBug
CELLSJAVA-41879%of, %of Row, %of ParentRowTotal, %ParentTotal, etc. are not working in pivot excel outputBug
CELLSJAVA-43062Cell’s default background color is wrong in output HTMLBug
CELLSJAVA-43063SheetRender.toImage() output is incorrectBug
CELLSJAVA-43070calculateFormula() does not calculate valueBug
CELLSJAVA-43086Percent Format Style is applied incorrectly under Norwegian LocaleBug
CELLSJAVA-43082Smaller font rendered in each first row of the tableBug
CELLSJAVA-41360Cells with formulas are displayed inside the PDF while they are not displayed inside the ODSBug
CELLSJAVA-42786ODS to XLSX - line graph loses lines and legends entriesBug
CELLSJAVA-42788ODS to XLSX - circle becomes squareBug
CELLSJAVA-43073DataMashup information not accessible in the workbookBug
CELLSJAVA-43092Cannot process Excel fileBug

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 ReplaceOptions.RegexKey property.

Indicates whether the searched key is regex. If true then the searched key(to be replaced part) will be taken as a user-specified regex.

Deletes obsoleted ValidationCollection.Add(Aspose.Cells.Validation) method.

Use ValidationCollection.Add(CellArea) method instead.

Adds PowerQueryFormula.FormulaDefinition property.

Gets the definition of the power query formula.

Adds DBConnection.PowerQueryFormula property.

Gets the definition of power query formula.

Adds HtmlSaveOptions.ExportHeadings property.

Indicates whether exporting headings when saving the file to HTML. The default value is false. If you want to import the HTML file to excel, please keep the default value.

Adds XAdESType class

Type of XML Advanced Electronic Signature (XAdES).

Adds DigitalSignature.XAdESType property

Gets and sets the type of XML Advanced Electronic Signature (XAdES). The default value is None(XAdES is off).