Aspose.Cells for Android via Java 22.9 Release Notes

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

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.