Aspose.Cells for Android via Java 22.12 Release Notes

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.

Changed the limit of moving cells out of the sheet for inserting rows

In old versions, if there are cells that have formatting settings but has no value?and will be moved out of the sheet, insert operation is not allowed. From 22.10, insert operation is allowed for such kind of situation and such behavior is same with ms excel now.

Adds DataModelConnection class

Specifies a data model connection.

Adds Chart.ChangeTemplate(byte[]) methods

Change chart type with preset template file.

Adds ChartCollection.Add(byte[] data, string dataRange, bool isVertical, int topRow, int leftColumn,int rightRow, int bottomColumn) method.

Adds chart with preset template file.

Adds Cell.IsDynamicArrayFormula property

Indicates whether the cell’s formula is dynamic array formula(true) or legacy array formula(false).

Obsoletes SparklineGroup.SparklineCollection property and adds SparklineGroup.Sparklines property

Use SparklineGroup.Sparklines property instead.

Obsoletes Worksheet.SparklineGroupCollection property and adds Worksheet.SparklineGroups property

Use Worksheet.SparklineGroups property instead.

Adds enum JsonExportHyperlinkType

Represents the type of exporting hyperlink to json files.

Adds JsonUtility.ExportRangeToJson(Range, JsonSaveOptions) and obsoletes ExportRangeToJson(Range, ExportRangeToJsonOptions) method

Use JsonUtility.ExportRangeToJson(Range, JsonSaveOptions) instead.

Adds PivotTable.DataFieldHeaderName property

Gets and sets the name of the value area field header in the PivotTable.

Adds override Range.SetStyle(Style,System.Boolean) method

Only overwrite formatting which is explicitly set when the flag is set

Adds PivotField.NonAutoSortDefault property

Indicates whether a sort operation that will be applied to this pivot field is an autosort operation or a simple data sort.

Adds GlobalizationSettings.GetDataFieldHeaderNameOfPivotTable() method

Gets the local name of the value area field header in the PivotTable.

Adds Chart.PlotVisibleCellsOnly property and obsoletes Chart.PlotVisibleCells property.

Use Chart.PlotVisibleCellsOnly property instead.

Adds JsonSaveOptions.ExportEmptyCells property.

Indicates whether exporting empty cells as null.

Adds JsonSaveOptions.ExportHyperlinkType property.

Represents the type of exporting hyperlink to json.

Adds JsonSaveOptions.ExportNestedStructure property.

Exported as parent-child hierarchy Json structure.

Adds JsonSaveOptions.SkipEmptyRows property.

Indicates whether skipping emtpy rows.

Deletes obsoleted SheetRender.GetPageSize(System.Int32) method

Use SheetRender.GetPageSizeInch(System.Int32) instead.

Deletes obsoleted WorkbookRender.GetPageSize(System.Int32) method

Use WorkbookRender.GetPageSizeInch(System.Int32) instead.

Deletes obsoleted AutoShapeType.TextWave3 and AutoShapeType.TextWave4 enum

Use UseAutoShape.TextDoubleWave1 and UseAutoShape.TextDoubleWave2 instead.