Aspose.Cells for Java 19.11 Release Notes

CELLSJAVA-43032Add Validation.addArea (CellArea cellArea, boolean skipArea) or Validation.setAreas() method/overloads to the APIsNew Feature
CELLSJAVA-42851Get ODATA connection detailsNew Feature
CELLSJAVA-43018Export print area range to HTML without implicitly changing some state of the same workbookEnhancement
CELLSJAVA-43041Cells.importCSV throws exception “string value cannot exceed 255 characters”Enhancement
CELLSJAVA-43043Cells.removeDuplicates takes more time for large datasetEnhancement
CELLSJAVA-43019Radial graph not rendered properly to HTMLBug
CELLSJAVA-43027After rendition to PNG scaling of the axis is different.Bug
CELLSJAVA-42474PivotTable is not refreshed and corrupted after updating the source dataBug
CELLSJAVA-43033Conversion to PDF doesn’t end.Bug
CELLSJAVA-43034Invalid Russian (custom) date format output is retrievedBug
CELLSJAVA-43040LoadFilter does not consider the required sheetBug
CELLSJAVA-43035Borders are lost while converting Excel file to EMFBug
CELLSJAVA-43016Invalid page count from SheetRenderBug
CELLSJAVA-43026After rendering chart to an image, Data Labels change style and values are not the sameBug
CELLSJAVA-43038HyperLinks not getting exported using Cell.setHtmlString()Bug
CELLSJAVA-43039Cell.setHtmlString() is not rendering certain HTML tags/scripts to Excel exportBug

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 methods: Validation.AddArea(CellArea,bool,bool),AddAreas(CellArea[], bool, bool),RemoveAreas(CellArea[])

Adds/Removes validation settings from given area(s) with performance consideration.

Adds Workbook.ImportXml(Stream stream, string sheetName, int row, int col) method.

Imports an XML file stream into the workbook.

Adds Workbook.ExportXml(string mapName, Stream stream) method.

Export XML data to a stream.

Adds HtmlSaveOptions.ExportArea property

Gets or Sets the exporting CellArea of current active Worksheet. If you set this attribute, the print area of the current active Worksheet will be omitted. Only the specified area will be exported when saving the file to HTML.

Adds classes : DataMashup,PowerQueryFormula,PowerQueryFormulaCollection,PowerQueryFormulaItem and PowerQueryFormulaItemCollection

Gets info in the DataMashup.

Adds DBConnection.SeverCommand property.

Gets and sets a second command text string that is persisted when PivotTable server-based page fields are in use. 

Adds CellsHelper.GetTextWidth() method.

Gets the width of the text in the unit of points.