Aspose.Cells for Android via Java 22.6 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.

Adds DefaultStyleSettings class.

Group of default values for style-related properties.

Adds LoadOptions.DefaultStyleSettings property.

Support to set default values of style-related properties for initializing a Workbook.

Adds TxtSaveOptions.TrimTailingBlankCells property.

Support to remove all blank cells(repeated characters of separator such as “~,~,~,~,”) at the end of row record when exporting csv/tsv.

Adds Style.HasBorders property.

Support to check whether there are borders have been set for the style.

Obsoletes LoadOptions.StandardFont/StandardFontSize properties.

Please use LoadOptions.DefaultStyleSettings.FontName/FontSize instead.

Removes obsolete enum StyleModifyFlag.FontSubscript and FontSuperscript.

Please use StyleModifyFlag.FontScript instead.

Obsoletes Shape.ConnectionPoints properties.

Use GetConnectionPoints() method instead.

Adds Shape.GetConnectionPoints() method.

Get the connection points.

Adds Row.IsCollapsed and Column.IsCollapsed properties.

Indicates whether the row and column is collapsed.

Adds PasteType.ValuesAndFormats enum.

Indicates only copying values and formats.

Adds Shape.IsInGroup property.

Indicates whether the shape is grouped.

Adds AutoFilter.GetCellArea() method.

Gets the area where the specified AutoFilter applies to.

Adds Cells.GetRowOriginalHeightPoint() method.

Gets the original row height, in unit of points.

Adds TimelineCollection.Add(PivotTable pivot, string destCellName, PivotField baseField) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, int row, int column, PivotField baseField) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, string destCellName, int baseFieldIndex) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, int row, int column, int baseFieldIndex) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, string destCellName, string baseFieldName) method.

Add a new Timeline using PivotTable as data source.

Adds DataLabelShapeType.Line enum.

Represents the Line Shape. This type is not available in Excel, it is only used for some special files.

Changes for saving Workbook with LightCells

To make formula-related features available for LightCells, in old versions we keep all formula data in cells model in memory when saving workbook with LightCells. This caused misunderstanding and misuse of LightCells for some users. User had thought that cell’s formula data has been released out of the scope of StartCell(Cell) but in fact not. For most users that use LightCells, their primary concern is performance(memory cost). Few people will use formula-related functions other than setting simple formula to the cell in the process of saving Workbook. So, from this version we add some restrictions for changing the cell object in the scope of StartCell(Cell) method. Now it is not allowed to set shared formulas, array formulas for the given cell object in StartCell(Cell) method. If such kind of formulas are needed, user should set them before saving workbook. With this change, we improved the performance for most users that need to save simple formula for cells to the resultant spreadsheet file with LightCells.

Deletes obsolete method Cell.SetAddInFormula()

Please use WorksheetCollection.RegisterAddInFunction() and Cell.Formula/Cell.SetFormula() instead.

Adds ExceptionType.FileCorrupted enum

Represents the type of exception is the file is corrupted.

Adds WarningType.Limitation enum

Represents the warning type is the limitation of Excel.

Adds ShapeGuideCollection.Add(string name, double val) method.

Adds a shape guide.

Adds CellsDataTableFactory class

This class provides apis to create instance of ICellsDataTable from custom objects for user’s convenience.

Adds Workbook.CellsDataTableFactory property

Provide user the CellsDataTableFactory for creating instance of ICellsDataTable from custom objects.

Adds Cell.GetDependentsInCalculation(bool) method

According to current calculation chain, get all cells whose calculated result depends on this cell.

Adds Cell.GetPrecedentsInCalculation() method

According to current calculation chain, get all precedents(reference to cells in current workbook) used by this cell’s formula while calculating it.

Obsoletes Cell.GetLeafs() and Cell.GetLeafs(bool) methods

Please use Cell.GetDependentsInCalculation(bool) method instead.

Adds PivotTable.FormatRow(int row, Style style) method

Format the row data in the pivottable area.

Adds Shapes.CreateId property

Gets creating id of the shape.

Adds WarningType.InvalidData enum

Represents the invalid data type.

Adds overload ChartCollection.Add() method

Adds a chart with data source.

Adds Chart.GetActualSize() method

Gets actual size of chart in unit of pixels.

Obsoletes Chart.ActualChartSize property

Please use Chart.GetActualSize() method instead.

Obsoletes PdfSaveOptions.ImageType property

Chart and Shape are always rendered as vector elements(e.g. point, line) for rendering quality.

Obsoletes ImageOrPrintOptions.ChartImageType property

Chart and Shape are always rendered as vector elements(e.g. point, line) for rendering quality.

Deletes obsolete property ImageOrPrintOptions.ImageFormat property

Please Use ImageOrPrintOptions.ImageType property instead.

Deletes obsolete property ImageOrPrintOptions.IsImageFitToPage property

The property is useless.