Aspose.Cells for Android via Java 22.6 Release Notes

This page contains release notes for Aspose.Cells for Android via Java 22.6.

Key	Summary	Category
CELLSJAVA-44632	Supports formatting the entire row of data in the PivotTable	New Feature
CELLSJAVA-44415	Thousand of the getResourceAsAStream calls causes high CPU load and memory consumption during report generation	Enhancement
CELLSJAVA-44490	add GridWorkbookSetting for GridWeb	Enhancement
CELLSJAVA-44554	Enhance the LightCells model for setting formulas	Enhancement
CELLSJAVA-44535	implement focus cell with vertical/horizontal scroll bar auto scroll to suitable postion	Enhancement
CELLSJAVA-44588	Detect file format for stream with password	Enhancement
CELLSJAVA-44611	Improvement for reading blank cells from xlsx file	Enhancement
CELLSJAVA-44616	Original settings of conditional formatting in the range of destination should be removed when copying range	Enhancement
CELLSJAVA-44658	Support BouncyCastle v1.71	Enhancement
CELLSJAVA-44455	When converting XLSX file to PDF, the date in the pivot table becomes a serial number	Bug
CELLSJAVA-44370	Excel file gets corrupt when opened and saved with Aspose.Cells	Bug
CELLSJAVA-44381	Condition formatting issue when deleting the row or column	Bug
CELLSJAVA-44442	Opening and saving with Aspose.Cells corrupts the workbook	Bug
CELLSJAVA-44356	picture position issue for print for the file fs.zip in GridWeb	Bug
CELLSJAVA-44357	issues for display ofd.zip in GridWeb	Bug
CELLSJAVA-44398	GridWeb display issues from customer	Bug
CELLSJAVA-44464	additional issue 1,column A background color is not same as in excel for yscl.xls at sheet4	Bug
CELLSJAVA-44466	additional issue 3,setCalculateFormula to false does not work	Bug
CELLSJAVA-44496	Include the caption tag/element for the table when loading html	Bug
CELLSJAVA-44429	The effect of Excel chart in excel is different from that in HTML	Bug
CELLSJAVA-44414	Unicode in JSON will break generated XLSX and CSV	Bug
CELLSJAVA-44481	Issue with ThreadedComment.setCreatedTime() method	Bug
CELLSJAVA-44483	Sorting not working after grouping the rows	Bug
CELLSJAVA-44522	Double value to string gives tailing zero which is incorrect when comparing with ms excel’s result	Bug
CELLSJAVA-44501	search next issue for the file duohangduolie.zip	Bug
CELLSJAVA-44529	implement search for freezepane	Bug
CELLSJAVA-44530	investigate the issue of setactivecell does not work sometimes	Bug
CELLSJAVA-44534	Graphic in print area not exported in Excel to HTML conversion	Bug
CELLSJAVA-44539	Chart is shifted to right while converting to html with print area	Bug
CELLSJAVA-44568	Multi-lines captions are lost except the first line in HTML to XLS conversion	Bug
CELLSJAVA-44512	Chart is missing while exporting chart to svg in html	Bug
CELLSJAVA-44556	Issue with data display in the data table after the coordinate axis is set to logarithmic scale - Excel to HTML/PDF conversion	Bug
CELLSJAVA-44628	How to retain percentage format of certain pivot rows when expanding node data of a pivot column/field	Bug
CELLSJAVA-44483	Sorting not working after grouping the rows	Bug
CELLSJAVA-44609	Slow copy with conditional formatting using newer version	Bug
CELLSJAVA-44622	When sorting large groups with multiple keys, it throws “java.lang.ArrayIndexOutOfBoundsException”	Bug
CELLSJAVA-44630	Issue with Smart Markers feature since Aspose Cells 22.5	Bug
CELLSJAVA-44646	Clear content on copied sheet throws NullPointerException	Bug
CELLSJAVA-44656	Cells.getMaxDataColumn returning different (wrong) value in 22.5	Bug
CELLSJAVA-44650	Excel document page is messy when loading into Aspose.Cells.GridWeb(Java)	Bug
CELLSJAVA-44660	Issue with data alignment when loading the XLS into Aspose.Cells.GridWeb (Java)	Bug
CELLSJAVA-44661	Issue when loading the et file into Aspose.Cells.GridWeb (Java)	Bug
CELLSJAVA-44584	The title of the axis in the chart is rotated in the output image - Chart to image conversion	Bug
CELLSJAVA-44615	Gray line drawn in the output image from XLS file	Bug
CELLSJAVA-44665	Loading ODS file hangs	Bug
CELLSJAVA-44404	Exception “java.lang.IllegalArgumentException: Invalid column index” when loading an XLSX file into GridWeb	Exception
CELLSJAVA-44651	“Not a numeric value” error when converting Excel sheet to HTML/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 DefaultStyleSettings class.

Group of default values for style-related properties.

Adds LoadOptions.DefaultStyleSettings property.

Support to set default values of style-related properties for initializing a Workbook.

Adds TxtSaveOptions.TrimTailingBlankCells property.

Support to remove all blank cells(repeated characters of separator such as “~,~,~,~,") at the end of row record when exporting csv/tsv.

Adds Style.HasBorders property.

Support to check whether there are borders have been set for the style.

Obsoletes LoadOptions.StandardFont/StandardFontSize properties.

Please use LoadOptions.DefaultStyleSettings.FontName/FontSize instead.

Removes obsolete enum StyleModifyFlag.FontSubscript and FontSuperscript.

Please use StyleModifyFlag.FontScript instead.

Obsoletes Shape.ConnectionPoints properties.

Use GetConnectionPoints() method instead.

Adds Shape.GetConnectionPoints() method.

Get the connection points.

Adds Row.IsCollapsed and Column.IsCollapsed properties.

Indicates whether the row and column is collapsed.

Adds PasteType.ValuesAndFormats enum.

Indicates only copying values and formats.

Adds Shape.IsInGroup property.

Indicates whether the shape is grouped.

Adds AutoFilter.GetCellArea() method.

Gets the area where the specified AutoFilter applies to.