Browse our Products

Aspose.Cells for Android via Java 24.6 Release Notes

KeySummaryCategory
CELLSJAVA-45821Support to place picture into cell(“Place in Cell” operation for picture in ms excel)New Feature
CELLSJAVA-45881Support getting original column widthNew Feature
CELLSJAVA-46003Fix error for loading unkown image supported by third party imageio pluginEnhancement
CELLSJAVA-45903Issue with copying images and shapes from one Excel file to anotherBug
CELLSJAVA-45906Full width characters not converted to half width characters when converting files to PDFBug
CELLSJAVA-45870Dotted lines in chart became solid lines when chart saved as EMF imageBug
CELLSJAVA-45874Row height error when converting file to htmlBug
CELLSJAVA-45892Rotated text rendering error when converting files to HTMLBug
CELLSJAVA-45897Cell data position error when converting file to HTMLBug
CELLSJAVA-45899Text cross column failure when converting file to HTMLBug
CELLSJAVA-45902new Workbook() on HTML stream very slowBug
CELLSJAVA-45864Pivot table Filter Selection and Formula Field Removal Issues in PNL_AFS and PNL-IslamicBug
CELLSJAVA-45879Regression: Refreshing the pivot table renders the chart incorrectlyBug
CELLSJAVA-45895The validation is not overwritten when copying a rangeBug
CELLSJAVA-45905Text size and shadow issues for shapes when re-saving an Excel 95 XLS file formatBug
CELLSJAVA-45912XLSB File Corruption During Pivot RefreshBug
CELLSJAVA-45915Data loss and only evaluation page left when converting files to HTMLBug
CELLSJAVA-45918After the same line of text is rendered, part of the text is offset downwardsBug
CELLSJAVA-45922Partial data of embedded Word object is not displayed when saving file to pdfBug
CELLSJAVA-45953Issue with calculating WORKDAY formula with Holidays referencesBug
CELLSJAVA-45961TEXTBEFORE and TEXTAFTER formulas cause exception in Workbook.calculateFormulaBug
CELLSJAVA-45919Intervals of X-axis tickmarks changed in the rendered image for ChartBug
CELLSJAVA-45949The Equation of Trendline in Chart are missing when saving file to pdfBug
CELLSJAVA-45972Gridline is too thicker when rendering to imageBug
CELLSJAVA-45957Problem with font-family extracting HTML from XLSXBug
CELLSJAVA-45944Support exporting Forms as ControlsBug
CELLSJAVA-45945Support getting original height of a hidden row in pixelsBug
CELLSJAVA-45981XLSX to PDF, curved line gets cut offBug
CELLSJAVA-45989Emf image rendering is incomplete.Bug
CELLSJAVA-45971Formulas are not fully calculated in large workbook unless it is opened in MS Excel to do the calculationsBug
CELLSJAVA-45996Wingdings fonts appear as gibberish in wordart in JavaBug
CELLSJAVA-45987Pictures are missing when converting file to PDFBug
CELLSJAVA-45973Data items are wrapped in <div> tags when converting files to HTMLBug
CELLSJAVA-45997Data loss when converting excel file to HTMLBug
CELLSJAVA-46009Pictures cannot be displayed when converting MHT to ExcelBug
CELLSJAVA-45983Table formatting lost when exporting to HTML (only from XLSB, not from XLSX)Bug
CELLSJAVA-45985Issue with merging two XLSX files with power-queries insideBug
CELLSJAVA-45993Issue in labels’ positions when saving as ByteArray and reconstructing the Workbook objectBug
CELLSJAVA-46004Result file data error when using smart marker with HashMap data sourceBug
CELLSJAVA-45990NullPointerException occured when calculating ASC function with JAPAN localeException
CELLSJAVA-45994NPE(java.lang.NullPointerException) when loading XLSB workbook with LightCellsDataHandlerException

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 classes SystemTimeInterruptMonitor and ThreadInterruptMonitor.

Provides two simple implementations of AbstractInterruptMonitor for user’s convenience to monitor and interrupt time-consumed procedures.

Adds class DeleteBlankOptions.

Provides options to define how to check blank cells for deleting blank rows and columns.

Removes obsolete property Worksheet.SparklineGroupCollection.

Please use Worksheet.SparklineGroups property instead.

Removes obsolete method Worksheet.SetBackground(byte[]).

Please use Worksheet.BackgroundImage property instead.

Adds HtmlTableLoadOption.TableToListObject and HtmlTableLoadOptionCollection.TableToListObject properties.

Indicates whether generate list objects from imported tables.

Adds HtmlTableLoadOptionCollection.Add(…) method.

Add a HtmlTableLoadOption to the list.

Obsolete HtmlTableLoadOption.Name property

Please use HtmlTableLoadOption.Id property instead.

Adds HtmlSaveOptions.HideOverflowWrappedText property.

Indicates whether to hide overflow text when the cell format is set to wrap text.

Adds PdfSaveOptions.EmbedAttachments property.

Indicates whether embedding Ole objects as attachments when converting Excel to pdf

Adds Cells.GetColumnOriginalWidthPoint() method.

Gets the original width of the hidden column.

Adds ExternalLink.PathType property.

Gets the relationship type of the external link.

Adds enum FileFormatType.WebP

Supports detecting the WebP image.

Adds PivotTable.RefreshData(PivotTableRefreshOption) method.

Customize the options of refreshing pivot table.

Adds Worksheet.RefreshData(PivotTableRefreshOption) method.

Customize the options of refreshing pivot tables in the worksheet.

Adds WorksheetCollection.RefreshData(PivotTableRefreshOption) method.

Customize the options of refreshing pivot tables in the workbook.

Adds GridWorkbookSettings.PreservePaddingSpaces property in GridWeb.

Gets or sets whether preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas. Default value is false.

Changes the returned value of FileFormatUtil.LoadFormatToExtension(LoadFormat.TabDelimited).

In old versions, we returned “txt” for tab delimited text file. From 24.5, we return the most specific extension of “tsv” for it.

Adds properties ReferredArea.IsEntireRow/IsEntireColumn.

Indicates whether the area reference is entire row or column.

Adds properties DefaultStyleSettings.BuiltInPreference and WorkbookSettings.DefaultStyleSettings.

Indicates which property should be used to format values when the used style defines both built-in number and custom pattern.

Adds HtmlSaveOptions.AddGenericFont property.

Indicates whether to add a generic font to CSS font-family when saving file to html.

Adds HtmlSaveOptions.IsBorderCollapsed property.

Indicates whether the table borders are collapsed when saving file to html.

Adds Range.UnionRanges() method and obsoletes Range.UnionRang() method.

Uses Range.UnionRanges() method instead.

Adds Range.Transpose() method.

Transposes the row to column of the range.

Adds AdvancedFilter class.

Represents the settings of advanced filter.

Adds Worksheet.GetAdvancedFilter(Int32,Boolean,CellsUnitType) method.

Gets the settings of advanced filter.

Add CellsUnitType enum.

Represents the unit type.

Adds Cells.GetRowHeight(Int32,Boolean,CellsUnitType) method and obsoletes Cells.GetRowOriginalHeightPoint() method.

Gets the height of the row in unit of type.

Adds GetColumnWidth(Int32,Boolean,CellsUnitType) method.

Gets the width of the column in unit of type.

Obsolets Cells.GetColumnOriginalWidthPoint(Int32), GetColumnWidthPixel(Int32,Boolean) and GetColumnWidthInch(Int32) methods.

Uses Cells.GetColumnWidth(Int32,Boolean,CellsUnitType) method instead.

Changes the behavior of Cells.ClearContents(CellArea)

In old versions, clearing contents will succeed even if the specified area intersects with part of existing array formula. In fact it produces corrupted formulas. From 25.6, this method will throw exception with message “Cannot change part of an array” for such situation.

Obsoletes property Shape.IsLockAspectRatio

Use Shape.IsAspectRatioLocked property instead.

Adds Shape.IsAspectRatioLocked property

True means that aspect ratio of the shape is locked. This property replaces the Shape.IsLockAspectRatio property.

Removes obsoleted property Shape.TextFrame

Use Shape.TextBody.TextAlignment property instead.

Removes obsoleted method FormatCharacters(int startIndex, int length, Font font)

Use Shape.FormatCharacters(int startIndex, int length, Font font, StyleFlag flag) method instead.

Adds PivotTable.GetFields(Pivot.PivotFieldType) method and obsolete PivotTable.Fields(Pivot.PivotFieldType) method

Use PivotTable.GetFields(Pivot.PivotFieldType) instead.

Adds JsonSaveOptions.ToExcelStruct property and Range.ToJson(JsonSaveOptions) method.

Supports converting range to json.

Adds PivotField.ShowValuesAs() method

Show values of data field as different display format when the ShowDataAs calculation is in use.

Adds PivotShowValuesSetting class and PivotField.ShowValuesSetting property

Gets the setting about “show values as”.

Adds Range.ToImage() method

Convert the range to image.

Adds Range.ToHtml() method

Convert the range to html.

Adds PivotItemPositionType enum

Represents base item Next/Previous/All position in the base field.

Adds PivotItem.IsFormula property

Indicates whether this pivot item is a calculuated item.

Obsolete properties of PivotFiled: DataDisplayFormat, BaseFieldIndex, BaseItemPosition and BaseItemIndex

Please use PivotField.ShowValuesAs() method and PivotField.ShowValuesSetting property instead.

Removes obsoleted property Shape.HeightInChart

Use Shape.HeightInShape property instead.

Removes obsoleted property Shape.LeftInChart

Use Shape.LeftInShape property instead.

Removes obsoleted property Shape.TopInChart

Use Shape.TopInShape property instead.

Removes obsoleted property Shape.WidthInChart

Use Shape.WidthInShape property instead.

Removes obsoleted property Shape.PositionX

Use Shape.X property instead.

Removes obsoleted property Shape.PositionY

Use Shape.Y property instead.