Aspose.Cells for Android via Java 22.9 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 Cells.GetDependentsInCalculation(int,int,bool) method

Gets all cells whose calculated result depends on the cell specified by row and column according to current calculation chain. For the cell which is empty and has not been instantiated in current cells model, user may use this method instead of Cell.GetDependentsInCalculation(bool) because the later one needs to instantiate the cell object into current cells model at first.

Changes cell’s Left/Right border for Cell.GetStyle() when the adjacent column is hidden

In old versions, if the adjacent column is hidden for one cell, then this cell’s Left/Right border will not be checked with the adjacent cell, so the returned border may be different from what shown in ms excel’s dialog when setting this cell’s border. From 22.7, we make the returned border always be the actual value(which should be consistent with the border of its adjacent cell) of the cell for Cell.GetStyle(). If user needs what shown for the cell in ms excel(when the adjacent column is hidden, the shown border may be the one of next visible column), user may try Cell.GetDisplayStyle().

Add Range.Top, Range.Left, Range.Height and Range.Width properties.

Gets the position and size of the range in unit of points.

Delete class PowerQueryFormulaCollction and add class PowerQueryFormulaCollection class.

There is a typo in the old class.

Add HtmlSaveOptions.ExportPageFooters and HtmlSaveOptions.ExportPageHeaders properties.

Indicates whether exporting headers and footers when saving as a single html file.

Adds HtmlSaveOptions.ShowAllSheets property.

Indicates whether showing all sheets when saving as a single html file.

Obsoletes HtmlSaveOptions.ExportHeadings property and add HtmlSaveOptions.ExportRowColumnHeadings property.

Please use HtmlSaveOptions.ExportRowColumnHeadings instead.

Obsoletes Chart.ToImage(string, ImageFormat) and add Chart.ToImage(string, ImageType)

Please use Chart.ToImage(string, ImageType) instead.

Add FontSettingCollection.Replace() method.

Replace the text of the shape.

Add ShapeTextAlignment.NumberOfColumns property.

Gets and sets the number of columns of the shape’s text.

Add HtmlSaveOptions.ExportCommentsType property.

Gets and sets the type of export comments to html.

Add base class PaginatedSaveOptions for PdfSaveOptions and XpsSaveOptions.

Represents the options for pagination.

Add class SheetSet.

Describes a set of sheets.

Add PaginatedSaveOptions.SheetSet property.

Gets or sets the sheets to render.

Add ImageOrPrintOptions.SheetSet property.

Gets or sets the sheets to render.

Add GridWeb.IgnoreStyleWithNoData property.

Gets or sets whether GridWeb ignores showing rows or columns that do not contain cell values but are still styled

Obsolete ImageOrPrintOptions.SaveFormat property.

For Tiff/Svg, please use ImageType; For Xps, please use Workbook.Save(string, SaveOptions) with XpsSaveOptions.

Obsolete constructor XpsSaveOptions(Aspose.Cells.SaveFormat saveFormat).

Please use constructor XpsSaveOptions() instead.

Obsolete constructor SvgSaveOptions(Aspose.Cells.SaveFormat saveFormat).

Please use constructor SvgSaveOptions() instead.

Remove constructor PdfSaveOptions(Aspose.Cells.SaveFormat saveFormat).

Please use constructor PdfSaveOptions() instead.

Adds Cell.SetTableFormula(…) methods

Support to set formulas for range of cells to create two-variable data table and one-variable data table.

Adds Cell.SetDynamicArrayFormula(string arrayFormula, FormulaParseOptions options, object[][] values, bool calculateRange, bool calculateValue, CalculationOptions copts) method

Support to set dynamic array formula with custom options for calculation, especially when there are functions which need user’s custom engine for calculation in the formula.

Adds Workbook.RefreshDynamicArrayFormulas(bool calculate, CalculationOptions copts) method

Support to refresh dynamic array formulas with custom options for calculation, especially when there are functions which need user’s custom engine for calculation functions in the dynamic array formulas.

Adds ChartFrame.TextOptions property.

Represents the font options of the chart’s text.

Adds ExportRangeToJsonOptions.ExportEmptyCells property.

Indicates whether exporting null if the cells are empty.

Add NumbersLoadOptions constructor.

Represents the options of loading numbers.

Adds enum LoadNumbersTableType.

Represnts the type of loading multi tables in a worksheet of the Mac .numbers.

Adds ProtectedRange.IsProtectedWithPassword property.

Inidicates whether the range is protected with password.

Adds ImportTableOptions.ExportCaptionAsFieldName properties

Indicates whether exporting caption as field name when importing data table.

Adds TextOptions.LanguageCode property.

Gets and sets the language code of the font.

Adds enum PresetThemeGradientType.

Represents the preset theme gradient type.

Adds GradientFill.SetPresetThemeGradient() method.

Sets the preset theme gradient type.

Adds override Style.SetBorder() methods.

Sets the borders with various kinds of color.

Adds Range.SetOutlineBorder() and Range.SetOutlineBorders() methods

Sets the borders of the range with various kinds of color.