Aspose.Cells for Android via Java 24.3 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 TxtLoadOptions.MaxRowCount/MaxColumnCount properties

Supports to import data from csv with user specified limit of rows and columns. If the data set is larger than the limit, it will be split into multiple worksheets according to the limit.

Adds TxtLoadOptions.HeaderRowsCount/HeaderColumnsCount properties

Supports to import data from csv with user specified header rows and headers to duplicated them for every extended worksheets.

Adds HtmlSaveOptions.CssStyles property

Gets or sets the additional css styles for the formatter.

Adds PivotField.GroupBy(double,bool) methods

Group the number or datetime pivot field.

Adds PptxSaveOptions.ExportViewType and enum SlideViewType

Indicates whether converting Excel to PowerPoint as View or Printing.

Adds FileFormatType.Oxps enum.

OXPS (Open XML Paper Specification) format.

Adds ChartCalculateOptions class.

The class represents the options for calculating chart.

Adds Chart.Calculate(ChartCalculateOptions) method.

Calculates the custom position of plot area, axes if the position of them are auto assigned, with specified options.

Adds Cells.GetColumnWidthPixel(Int32, Boolean) method

Gets the original width of the hidden columns.

Adds ExportTableOptions.AllowDBNull property

Indicates whether the column allows null values.

Removes obsolete indexer Cells.get(int index).

Please use Cells.GetEnumerator() method to iterate all cells.

Removes obsolete method Cells.FindFormula(string formula, Cell previousCell).

Please use Cells.Find(object,Cell,FindOptions) method instead, with LookInType.OnlyFormulas and LookAtType.EntireContent.

Removes obsolete method Cells.FindFormulaContains(string formula, Cell previousCell).

Please use Cells.Find(object,Cell,FindOptions) method instead, with LookInType.OnlyFormulas and LookAtType.Contains.

Removes obsolete property Range.CellCount.

Please use Range.RowCount and Range.ColumnCount to get total cells count instead.

Removes obsolete property Row.Style.

Please use Row.GetStyle() method instead.

Removes obsolete property WorkbookSettings.ParsingFormulaOnOpen.

Please use LoadOptions.ParsingFormulaOnOpen property instead.

Removes obsolete properties of WorkbookSettings about formula.

Please use properties of FormulaSettings instead.

Removes obsolete property of FilterColumn.Visibledropdown.

Please use FilterColumn.IsDropdownVisible property instead.

Removes obsolete class ICustomFunction and related apis referencing to it.

Please use AbstractCalculationEngine and CalculationOptions.CustomEngine instead for:

CalculationOptions.CustomFunction
Workbook.CalculateFormula(bool, ICustomFunction)
Worksheet.CalculateFormula(bool, bool, ICustomFunction)
Cell.Calculate(bool, ICustomFunction)

Removes obsolete method Cells.getCell(int row, int column).

Please use Cells.get(int row, int column) instead.

Removes obsolete methods Cells.getRow(int rowIndex)/getColumn(int columnIndex).

Please use Cells.getRows().get(int rowIndex)/Cells.getColumns().get(int columnIndex) instead.

Removes obsolete methods Area.isVisible()/isAuto()/setAuto(bool).

Please use Area.Formatting property instead.

Removes obsolete methods Axis.isAutoCross()/setAutoCross()/isCrossAtMax()/setCrossAtMax(bool).

Please use Axis.CrossType property instead.

Removes obsolete properties about formula for WorkbookSettings.

ParsingFormulaOnOpen
PrecisionAsDisplayed
ReCalculateOnOpen
CreateCalcChain
ForceFullCalculate
Iteration
MaxIteration
MaxChange
CalcMode
CalculationId
CalcStackSize
RecalculateBeforeSave

Please use corresponding properties of FormulaSettings instead.

Removes obsolete property DataLabels.Separator and corresponding enum DataLablesSeparatorType.

Please use DataLabels.SeparatorType and corresponding enum DataLabelsSeparatorType instead.

Obsoleted OdsSaveOptions.IsStrictSchema11 property.

Use OdsSaveOptions.OdfStrictVersion property instead.

Adds OdsSaveOptions.OdfStrictVersion property.

The generated ods files complie with the strict of ODF.

Adds MergeEmptyTdType enum.

Represents the merge type for empty TD element when exporting file to html.

Adds HtmlSaveOptions.MergeEmptyTdType property.

The option to merge contiguous empty cells(empty td elements).

Obsoleted HtmlSaveOptions.MergeEmptyTdForcely property.

Use HtmlSaveOptions.MergeEmptyTdType property instead.

Adds TickLabelAlignmentType enum.

Represents the text alignment type for the tick labels on the axis.

Adds TickLabels.AlignmentType property.

Gets and sets how to align the tick labels of the axis.

Adds FileFormatType.Azw3, LoadFormat.Azw3 enum.

AZW3 format.

Adds PivotItem.IsMissing property.

Indicates whether this item does not exist in the data source of pivot table.