Aspose.Cells for Android via Java 20.6 Release Notes

KeySummaryCategory
CELLSJAVA-43153Display waterfall chart legend in Turkish similar to MS ExcelEnhancement
CELLSJAVA-43173When the group field has a null value, the result of subtotalN loses the subtotal for the null groupEnhancement
CELLSJAVA-43186Calculate the grand total for every row with expanded columnEnhancement
CELLSJAVA-43191Provide a means to handle scenarios when specifying incorrect font typesEnhancement
CELLSJAVA-43187Exception when loading an XLS “Microsoft Excel 5.0 / 95 Workbook” filesEnhancement
CELLSJAVA-43142Excel to HTML rendering - some cells are not aligned after conversionBug
CELLSJAVA-43155Rotated text is set out of the cell when rendered as HTMLBug
CELLSJAVA-43161Incorrect rendering of the equationBug
CELLSJAVA-43130Waterfall chart transparency issueBug
CELLSJAVA-43131Excel to PDF - Shapes with text not converted properlyBug
CELLSJAVA-43133Chart.toImage does not include data labels in the output imageBug
CELLSJAVA-43138Image generated with rendering issue.Bug
CELLSJAVA-43151Styling changes after conversion of XLS fileBug
CELLSJAVA-43162Excel to HTML rendering - the conversion process takes a long timeBug
CELLSJAVA-43164HTML to Excel conversion not retaining the rich text formats in the outputBug
CELLSJAVA-43166Rotated text is not rendered properly in XLSX to HTML conversionBug
CELLSJAVA-43178RichText formattings are lost when exporting the file to HTMLBug
CELLSJAVA-43165String “20TT1” replaced with number 43850 during CSV to XLSB conversionBug
CELLSJAVA-43026After rendering chart to an image, Data Labels change the style, and values are not the sameBug
CELLSJAVA-43154Some chart points overlap by labelBug
CELLSJAVA-43089The Radar chart is flipped and axis values are not identical with the original chart in XLS to PDF conversionBug
CELLSJAVA-43171The document is broken after copying the sheetsBug
CELLSJAVA-43172An issue with smart markers in merged cellsBug
CELLSJAVA-43180HTML to Excel conversion creating black worksheet outputBug
CELLSJAVA-43181There is a difference in row height in converting Excel to HTMLBug
CELLSJAVA-43188The background color style is not being retained during HTML to Excel conversionBug
CELLSJAVA-43196There is a different number of VBA modules detected by using Aspose.Cells for Java 20.4 and 20.5Bug
CELLSJAVA-43202The resources are not released on workbook creation completionBug
CELLSJAVA-43203Unable to process some Excel validation lists based on the named ranges with Unicode namesBug
CELLSJAVA-43185JPEG quality is always 75 on setImageResample on LinuxBug
CELLSJAVA-43192Load font folder /System/Library/Fonts on macOS by defaultBug
CELLSJAVA-43157Customized data series color is not preserved when creating a Waterfall chartBug
CELLSJAVA-43175An issue with chart series name when referencing workbook to other workbooksBug
CELLSJAVA-43158IllegalArgumentException: Map size(0) must be >= 1Exception
CELLSJAVA-43149Exception raised while saving XLSM after removing worksheetException
CELLSJAVA-43150Exception “java.lang.NumberFormatException” on file loadingException
CELLSJAVA-43183Exception “ClassCastException: ….” when calculating PivotTableException
CELLSJAVA-43177New Workbook with CSV file results in “java.lang.IndexOutOfBoundsException: millisecond”Exception
CELLSJAVA-43168Exception “IllegalStateException: This is not a structured storage file” when merging Excel filesException
CELLSJAVA-43179Exception NumberFormatException: For input string: “preserve”Exception
CELLSJAVA-43182Exception ’lang.IllegalStateException: Invalid encoding: null’ while loading XLS fileException
CELLSJAVA-43201Exception “java.util.EmptyStackException” on saving to HTMLException
CELLSJAVA-43204NegativeArraySizeException occurs when using Cell.getDisplayStringValue()Exception
CELLSJAVA-43189Exception raised while loading the XLS fileException
CELLSJAVA-43193NullPointerException occurred when loading some XLSX filesException
CELLSJAVA-43200Exception “java.lang.ArrayIndexOutOfBoundsException” on loading the 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 Android via Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds ChartTextFrame.DirectionType property.

Gets and sets the direction of text in the chart.

Adds ChartTextFrame.ReadingOrder and obsoletes ChartTextFrame.TextDirection property.

Use ChartTextFrame.ReadingOrder property instead.

Adds classes for the enhanced features of Revisions.

Gets the information of the revision.

Changes default value of TxtSaveOptions.TrimLeadingBlankRowAndColumn property.

To make the default behavior of saving CSV the same with ms excel, we changed the default value and behavior of this property. For old versions, its default value was “false”. From 20.4, its default value becomes “true”.

Changes the behavior for detecting blank rows/columns for saving CSV.

For old versions, we took those rows/columns which have no data but have custom settings(visibility, formatting, …etc.) as blank. From 20.4, we do not take them as blank anymore, the new behavior is the same with ms excel.

Adds TxtSaveOptions.ExportArea property.

Specifies the range of cells data to be exported. Users may use this option to get the same result with old versions for the changed behavior of TxtSaveOptions.TrimLeadingBlankRowAndColumn and blank rows/columns.

Adds UnionRange class.

Represents union range.

Deletes obsoleted DrawObject.Image property.

Use DrawObject.ImageBytes property instead.

Adds Bullet.FontName property

Gets and sets the font name of the bullet.

Adds WorksheetCollection.CreateUnionRange() method.

Creates a union range.

Deletes obsoleted SaveType enum.

It’s unused.

Deletes obsoleted OleObject.ImageFormat and Pictuer.ImageFormat properties.

Use OleObject.ImageType and Picture.ImageType properties instead.

Adds WorkbookSettings.GetThemeFont() method.

Gets theme font.

Adds DataLabels.LinkedSource property.

Gets and sets the linked source.

Adds DefaultEditLanguage enum.

Represents the default edit language.

Adds ImageOrPrintOptions.DefaultEditLanguage property.

Gets or sets default edit language. It may display/render different layouts for text paragraphs when different edit languages are set.

Adds PdfSaveOptions.DefaultEditLanguage property.

Gets or sets default edit language. It may display/render different layouts for text paragraphs when different edit languages are set.

Adds ReferredArea.GetValues(bool calculateFormulas)/GetValue(int rowOffset, int colOffset, bool calculateFormulas) method.

It gives the user the ability to control whether formulas should be calculated recursively in the implementation of AbstractCalculationEngine.

Adds WarningType.InvalidFontName and WarningType.InvalidTextOfDefinedName enum.

Represents the warning type.

Adds WarningInfo.CorrectedObject and WarningInfo.ErrorObject properties.

Represents the wrong data and updated data when a warning is thrown.

Adds WorkbookDesigner.RepeatFormulasWithSubtotal properties.

Indicates whether repeating formulas with subtotal rows.

Adds PlotArea.IsAutomaticSize property.

It indicates whether the size of the plot area is automatic.

Deletes obsoleted Style.Rotation property.

Use Style.RotationAngle property instead.

Adds Gridweb.SetFontFolder(string fontFolder, bool recursive)/SetFontFolders(string[] fontFolders, bool recursive) method.

Sets the fonts folder/folders