Aspose.Cells for Android via Java 23.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 XlsbSaveOptions.LightCellsDataProvider property

Allows user to save xlsb file in LightCell mode.

Adds Worksheet.CalculateArrayFormula(…) methods

Allows user to calculate one formula as array formula dynamically without setting it to a cell at first.

Adds CalculationOptions.CharacterEncoding property

Allows user to specify the encoding used for encoding/decoding characters when calculating formulas such as CHAR and CODE function.

Adds EquationNode class and it’s derived classes

Allows users to complete the construction of an equation shape by inserting relevant nodes step by step.

Adds FileFormatType.XHtml and FileFormat.OneNote enums

Represents the xhtml and One Note file format type.

Adds FontConfigs.IsFontAvailable() method

Returnes whether the font is available.

Adds LoadOptions.IgnoreUselessShapes property

Indicates whether ignoring useless shapes in the xlsx files.

Adds PivotArea.OnlyData and OnlyLabel properties.

Represents whether only selecting data or lable for pivot area.

Adds SaveFormat.XHtml enum.

Represents the saving format.

Adds ListObject.PutCellFormula() method

Puts formula to the cells in the table.

Adds VbaProject.Encoding property

Gets and sets the encoding of VBA project in the Excel files.

Adds XmlSaveOptions.SheetNameAsElementName property.

Indicates whether saving sheet name as element name when converting excel to xml data.

Adds XmlSaveOptions.DataAsAttribute property.

Indicates whether saving data as attribute of node when converting excel to xml data.

Changes behavior of ExternalLinkCollection.Clear(bool)/RemoveAt(int,bool) methods

In old versions, when “updateReferencesAsLocal” is true, we only update those references of external names to local names of current workbook. For references of external sheet data, we updated them as “#REF!” always. From 23.5, if there is one worksheet in current workbook with the same sheet name of the external reference, then the reference will be updated to the local sheet too.

Adds Row.iterator(bool reversed, bool sync) method

Provide user the ability of traversing Cell in reversed order.

Obsoletes Cells.getRowEnumerator()

Please use RowCollection.iterator() instead.

Obsoletes Chart.IsReferedByChart() method and adds Chart.IsCellReferedByChart() method

Please use Chart.IsCellReferedByChart() instead.

Adds SeriesLayoutProperties.IsIntervalLeftClosed property

Indicates whether the interval is closed on the left side.

Adds ShapeTextAlignment.IsLockedText property

Indicates whether the text of the shape is locked.

Removes obsoleted ShapeFormat class and Shape.ShapeFormat

Use Shape.Line and Shape.Fill property instead.

Adds ListColumn.TotalsRowLabel property

Gets and sets the label of totals row in the table.

Adds ListObject.PutCellValue(Int32,Int32,Object,Boolean) method

Sets the value to the cell in the table.

Adds PivotAreaType enum and PivotArea.RuleType property

Gets and sets the type of pivot area in the pivot table.

Adds PivotTableFormat class

Represents the format for the PivotTable.

Adds PivotTableFormatCollection class

Represents all formats for the PivotTable.

Adds PivotTable.PivotFormats property

Gets and adds all formats for the PivotTable.

Adds PivotTable.AutofitColumnWidthOnUpdate property

Indicates whether auot fitting column width when refreshing PivotTable.

Adds PivotAreaFilter and PivotAreaFilterCollection class

Represents the filters to select pivot area in the PivotTable.

Adds PivotArea.Filters property

Represents the filters to select pivot area in the PivotTable.

Adds PivotArea.IsRowGrandIncluded and PivotArea.IsColumnGrandIncluded properties

Indicates wehther including row or column grand total into the area.

Adds PivotArea.AxisType property

Gets and sets the region of the PivotTable to which this rule applies.

Adds PivotArea.IsOutline property

Indicates whether the rule refers to the pivot area that is in outline mode.

Adds ImageOrPrintOptions.SetDesiredSize(int desiredWidth, int desiredHeight, bool keepAspectRatio) method

Sets desired width and height of image, and specify whether to keep aspect ratio of origin image.

Obsoletes ImageOrPrintOptions.SetDesiredSize(int desiredWidth, int desiredHeight) method

Please use ImageOrPrintOptions.SetDesiredSize(desiredWidth, desiredHeight, false) instead.

Adds PdfSaveOptions.Watermark property

Gets or sets watermark to output.

Adds RenderingFont and RenderingWatermark classes

For adding watermark to output of rendering.

Adds AutoFitterOptions.ForRendering property

Indicates whether fit for rendering purpose.

Changes definition of EquationNodeParagraph.EquationHorizontalJustificationType

Change from instance variable to property/method access.

Changes behavior of Cells.DeleteBlankRows() method

In old versions, we did not take a row as blank if it intersects some merged cells so it will not be deleted. From 23.6, if one row intersects some merged cells only and has no cell data or other related objects, it will be taken as blank and will be deleted.

Changes behavior of constructing save options with mismatched save format

For constructing specific save options with save format, sometimes user may provide unmatched format as the parameter. In old version the unmatched format may be accepted directly, this may cause ambiguities and even unexpected result. From 23.6, we reset the unmatched save format to a default one which matches the specific save options. Those influenced save options and default format are: OoxmlSaveOptions-xlsx, HtmlSaveOptions-html, OdsSaveOptions-ods, XlsSaveOptions-xls.

Adds RowCollection.iterator(bool reversed, bool sync) method

Provides user the ability of traversing Row objects in the collection in reversed order.

Obsoletes XlsSaveOptions.IsTemplate method

For template file, please create save options by XlsSaveOptions(SaveFormat.Xlt). Otherwise create it by XlsSaveOptions().

Adds ListColumn.GetDataStyle() and ListColumn.SetDataStyle(Style) methods.

Gets and sets the style of the column in the table.

Adds ListObject.PutCellFormula(int,int,string,bool) method.

Sets the formula to table.

Adds RevisionLogCollection.HighlightChanges(HighlightChangesOptions) method and HighlightChangesOptions class.

Exports and highlights all revision logs to a new worksheet.

Adds FileFormatType.GZip enum.

It’s used to detect whether the file is GZip file.