Aspose.Cells for Android via Java 22.9 Release Notes

CELLSJAVA-44721Support sorting PivotField via calculated fieldNew Feature
CELLSJAVA-44811Support to specify sheets to output while exporting to pdf/xpsNew Feature
CELLSJAVA-44194Drawing shape is not rendered in Excel to PDF renderingNew Feature
CELLSJAVA-44733Investigate rules of ms excel to display cell’s border when adjacent column is hidden: cell’s border has not been synchronizedEnhancement
CELLSJAVA-44777Export formulas to html only depending on HtmlSaveOptions.Exportformula optionEnhancement
CELLSJAVA-44791Enhance parsing html string to cellEnhancement
CELLSJAVA-44695Bad conversion to PDF from XLS with Line Callout at the left of the sheetBug
CELLSJAVA-44700Pivot table calculated fields not getting refreshed on updating data sourceBug
CELLSJAVA-44705Cell.getDependents() throws Exception or cannot provide all dependentsBug
CELLSJAVA-44717Issue with border (line) styleBug
CELLSJAVA-44707border line does not displayBug
CELLSJAVA-44670Issue with Formulas in the output HTML - Excel to HTML conversionBug
CELLSJAVA-44202When exporting to HTML, the legend in the chart is not the same as MS ExcelBug
CELLSJAVA-44591Text rotation of labels does not match with Excel in the output image of the chartBug
CELLSJAVA-44655Unable to display Treemap chart with negative value causing execution to keep runningBug
CELLSJAVA-44686The title text of chart(2016) is incorrect when Title.IsAutoText is trueBug
CELLSJAVA-44689Regression: Waterfall chart legend language issueBug
CELLSJAVA-44687Chart issue during combining filesBug
CELLSJAVA-44736Table styling lost when copying sheetBug
CELLSJAVA-44740Setting date before 1581 to a cell generated incorrect date stringBug
CELLSJAVA-44758Copy worksheet across workbooks, the cell format is abnormalBug
CELLSJAVA-44796Aspose.Cells formula calculation engine produces ?#N/A? values for certain cellsBug
CELLSJAVA-44798Bug of formatting 0.9999999999999999 with custom “#” for JDK8 or later versionsBug
CELLSJAVA-44773Data is messed up when opening an Excel document with hidden columns into GridWeb (Java)Bug
CELLSJAVA-44781investigate the row resize issue when resize to very little heightBug
CELLSJAVA-44787Bottom border lost at the last row in the workbookBug
CELLSJAVA-44761Excessive memory usage on conversion of Excel file to HTMLBug
CELLSJAVA-44801Excel to PDF conversion using Aspose.Cells for Java v22.7 causes garbled charactersBug
CELLSJAVA-44741Line break is not right in the output xlsx after set html string into cellBug
CELLSJAVA-44776Table header row styling lost when copying sheetBug
CELLSJAVA-44789Issue with character string replacement of textbox placed in Excel spreadsheetBug
CELLSJAVA-44792Endless saving workbook to HTML format (2892)Bug
CELLSJAVA-44864Concurrent loading of workbooks throws spurious “File is corrupted” errorsBug
CELLSJAVA-44327Borders and fewer lines shown in black and white pie slices in chart to image renderingBug
CELLSJAVA-44591Text rotation of labels does not match with Excel in the output image of the chartBug
CELLSJAVA-44775Chart labels overlapped in chart to image renderingBug
CELLSJAVA-44860the display of cell text does not same as in excel in some merged areasBug
CELLSJAVA-44832Multi pages are output instead of one page as in Excel while converting to pdfBug
CELLSJAVA-44812Unable to decrease the plot area for the chartBug
CELLSJAVA-44831MS Word prompts an error “Word found unreadable content in…” when opening the converted DOCX from XLSX file by Aspose.Cells for JavaBug
CELLSJAVA-44833Text color is not applied to different words or part of contents in the output Excel file when using Cell.setHtmlString() methodBug
CELLSJAVA-44852The border is incorrect when the static Excel file is converted to HTMLBug
CELLSJAVA-44856Excel to HTML conversion - Sparkline (mini chart) is not displayed/renderedBug
CELLSJAVA-44859Some Html formattings are not working for worksheet cells in an existing Excel fileBug
CELLSJAVA-44725Exception “ invalid entry size (expected 0 but got 1053 bytes)” while converting XLSX to PDFException
CELLSJAVA-44763Exception “java.lang.IllegalArgumentException: can’t parse argument number: 1:X8” when loading the Excel file using “”Exception
CELLSJAVA-44774Error when saving as PDF - Investigation requiredException
CELLSJAVA-44842Exception “java.lang.OutOfMemoryError: Java heap space” when converting an XLSX file to PDFException

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.