Aspose.Cells for Java 16.12.0 Release Notes

KeySummaryCategory
CELLSJAVA-42043Specify Chart points’ positionsNew Feature 
CELLSJAVA-42073XLSM becomes corrupted after re-save operationBug 
CELLSJAVA-42060DataBar width is not correct while converting spreadsheet to HTMLBug 
CELLSJAVA-42016Orange Row is not included in the SUM of Pivot TableBug 
CELLSJAVA-42006Image is cut off in the output HTML Bug 
CELLSJAVA-42067Chart is missing while converting spreadsheet to HTMLBug 
CELLSJAVA-41983Row height is not correct while converting XLSX to HTMLBug 
CELLSJAVA-42089DCOUNTA Excel formula is not evaluated fine by Aspose.Cells formula calculation engineBug 
CELLSJAVA-42081Issue with DataBar conditional formatting when saving an XLSM file as PDFBug 
CELLSJAVA-42100The space between certain characters gets removed at a few places in the output PDF fileBug 
CELLSJAVA-42078Chart labels are not displayed/rendered the same (as per the original Excel file) in the output PDF fileBug 
CELLSJAVA-42077Issue with font attributes of TextBox in the output PDFBug 
CELLSJAVA-42064TextBox’s content color & size is changed while converting worksheet to EMFBug 
CELLSJAVA-42063TextBox’s content color & size is changed while converting spreadsheet to PDFBug 
CELLSJAVA-42059Hebrew words are not rendered correctly when converting an Excel file to PDF file formatBug 
CELLSJAVA-42053Content in TextBox is clipped while rendering spreadsheet to PDFBug 
CELLSJAVA-42052Arrowed lines are misplaced while rendering spreadsheet to PDFBug 
CELLSJAVA-42049Issue with the SVG image of the chart in the rendered HTML fileBug 
CELLSJAVA-42036Font substitution does not seem to take effect for Chart legend while using Chart.toPdf() Bug 
CELLSJAVA-42024Legend overlapping with text in Chart’s PDFBug 
CELLSJAVA-42070Incorrect ChartPoint’s ShapeXPx & ShapeYPx valuesBug 
CELLSJAVA-42083Incomplete rendering of the Rectangle shape while converting XLS to HTML Bug 
CELLSJAVA-42104Text is getting truncated while converting spreadsheet to PDF file formatBug 
CELLSJAVA-42098Extra pages are added due to some pages are not rendered completely in one PDF pageBug 
CELLSJAVA-42097SheetRender - Invalid column indexBug 
CELLSJAVA-42093Extending Excel Table modifies dataBug 
CELLSJAVA-42092Opening and saving the file while using SheetRender corrupts the output Excel fileBug 
CELLSJAVA-42085Setting the shape text changes the text styleBug 
CELLSJAVA-42074Text of some cells like C2 and C3 get unboldBug 
CELLSJAVA-42058Worksheet.autoFitColumns method does not seem to take effect when required font is not present in LinuxBug 
CELLSJAVA-42054Unexpected background color applied to TextBoxes while rendering spreadsheet to PDFBug 
CELLSJAVA-42072java.lang.ArrayIndexOutOfBoundsException at Workbook.calculateFormula(false)Exception 
CELLSJAVA-42066CellsException at Workbook.save while converting an XLS to PDFException 
CELLSJAVA-42101Invalid Formula exception on opening the Excel fileException 
CELLSJAVA-42080Exception on saving the workbookException 

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 BuiltInDocumentPropertyCollection.ScaleCrop and BuiltInDocumentPropertyCollection.LinksUpToDate properties

Gets and sets some builtin document properties.

Deletes obsoleted DataLabels.Rotation property

Use DataLabels.RotationAngle property instead.

Deletes obsoleted Title.Rotation property

Use Title.RotationAngle property instead.

Deletes obsoleted DataLabels.Background property

Use DataLabels.BackgroundMode property instead.

Deletes obsoleted DisplayUnitLabel.Rotation property

Use DisplayUnitLabel.RotationAngle property instead.

Deletes obsoleted Title.getCharacters() method

Use Title.characters() method instead.

Adds LoadFilter class and LoadOptions.LoadFilter property

Allows user to control what data should be loaded while loading a Workbook from template file.

Obsoletes LoadOptions.LoadDataFilterOptions property

Use LoadOptions.LoadFilter property instead. Example: LoadOptions.LoadFilter = new LoadFilter(LoadDataFilterOptions.All & ~LoadDataFilterOptions.Chart);

Obsoletes LoadOptions.OnlyLoadDocumentProperties property

Use LoadOptions.LoadFilter property instead. Usage: LoadOptions.LoadFilter = new LoadFilter(LoadDataFilterOptions.DocumentProperties);

Obsoletes LoadOptions.LoadDataAndFormatting property

Use LoadOptions.LoadFilter property instead. Usage: LoadOptions.LoadFilter = new LoadFilter(LoadDataFilterOptions.CellData);

Obsoletes LoadOptions.LoadDataOptions property

Use LoadFilter property instead, user may extend LoadFilter to filter the worksheet and data.

Adds Workbook.ExportXml(string mapName, string path) method

Export XML data.

Adds enum FileFormatType.OTS

Represents the OTS file format.

Adds WorksheetCollection.CreateRange() method

Creates a range.

Adds FontConfigs.PreferSystemFontSubstitutes property

Indicate whether to use system font substitutes first or not when a font is not presented and the substitute of this font is not set.