Aspose.Cells for Android via Java 21.9 Release Notes

CELLSJAVA-43477Digitally Sign a VBA Code Project with Certificate using Aspose.Cells for JavaNew Feature
CELLSJAVA-40452Get external data ranges and detailsNew Feature
CELLSJAVA-42494Large amount of unused styles being generated into the CSS sectionEnhancement
CELLSJAVA-43639Creation date and time and modification date cannot be extractedEnhancement
CELLSJAVA-41121SheetRender does not render the flow chart correctlyBug
CELLSJAVA-43331Missing text in circle during XLS to HTML conversionBug
CELLSJAVA-43507When executing svg to insert excel under java, it exits abnormally.Bug
CELLSJAVA-41887Percentage data from a Pivot Table is not showing properly in HTMLBug
CELLSJAVA-43482Superscripts and subscripts not formatted correctly when converting an HTML document to a WorkbookBug
CELLSJAVA-43501Incorrect value read using getStringValue() functionBug
CELLSJAVA-43515MDURATION formula issueBug
CELLSJAVA-43528Creation date and time and update date cannot be extractedBug
CELLSJAVA-43529Unable to extract BuiltInDocumentPropertiesBug
CELLSJAVA-43530Date and time property results are differentBug
CELLSJAVA-41693Equation in a TextBox does not render to PDFBug
CELLSJAVA-43487Text not centered in the output PDF in Excel to PDF conversionBug
CELLSJAVA-42867Shapes are not retrieved in the ODS file formatBug
CELLSJAVA-42895PNG output of MS Excel chart has discrepanciesBug
CELLSJAVA-43015Issue with SheetRender.toImage() while using setPrintArea() methodBug
CELLSJAVA-43258Chart points font boldness changes after workbook copyBug
CELLSJAVA-43436Aspose Cells ignores inverted y-axis in diagramBug
CELLSJAVA-43510Chart is messed up upon re-saving the Excel file using Aspose.Cells for JavaBug
CELLSJAVA-43532Problem extracting chart series namesBug
CELLSJAVA-43474Shape objects changed while loading and saving XLS fileBug
CELLSJAVA-43493Incorrect comment’s author is retrievedBug
CELLSJAVA-43576Graphic text values are not displayed when converting XLSX to PDFBug
CELLSJAVA-43483Text after a “br” tag within an “em” tag is not emphasized when converting an HTML document to a WorkbookBug
CELLSJAVA-43526IllegalArgumentException: Invalid column indexBug
CELLSJAVA-43557Incorrect color when save as htmlBug
CELLSJAVA-43567Regression: MDURATION formula not calculated properlyBug
CELLSJAVA-43583Power operator “^” is not working for formula calculationsBug
CELLSJAVA-43549Image missing in the Output PDFBug
CELLSJAVA-43566Default fonts on MacOS Big SurBug
CELLSJAVA-42579Axis Labels are not displaying correctly - Right Alignment missing when saving Excel to PdfBug
CELLSJAVA-43554Chart datatable text is not shown int the output imageBug
CELLSJAVA-43556XLSX to PDF: Incomplete diagram titleBug
CELLSJAVA-40051Apple iWork SupportBug
CELLSJAVA-43119Conversion to PDF - Unsupport file format Number3.5 since 2014Bug
CELLSJAVA-43538Chart with No Data causes XLSX to become corrupt after saving with Aspose CellsBug
CELLSJAVA-43547AutoFitRow changes worksheet standard heightBug
CELLSJAVA-43591Error when open file in MS Excel saved by Aspose.CellsBug
CELLSJAVA-43622XLSX to PDF: Shape to image ErrorBug
CELLSJAVA-43756Image distortion during Excel to HTMLBug
CELLSJAVA-43309Details changed on Excel to HTML conversionBug
CELLSJAVA-43578Formatting issues while converting Excel to HTMLBug
CELLSJAVA-43579Text Alignment issue during Excel to HTML conversionBug
CELLSJAVA-43630Hyperlink function hyperlink is invalid when Excel is converted to HTMLBug
CELLSJAVA-43635When exporting html, the length of the data bar is shorter than that in excelBug
CELLSJAVA-43709Re-saved XLSM file cause file corruption popup when opening by ms excelBug
CELLSJAVA-43758Array formula evaluation problemBug
CELLSJAVA-43680Databar issue of conditional formatting in the generated pdfBug
CELLSJAVA-43689Setting the conditional formatting to cell and using DataBar.toImage result in blank pictureBug
CELLSJAVA-43723The font in the cell is not fully displayed When Excel file is converted to PDFBug
CELLSJAVA-43724Not able to convert complex HTML into CSVBug
CELLSJAVA-43728Text orientation changed while Excel to PDF conversionBug
CELLSJAVA-43752Excel to HTML rendering - issue with conditional formatting to hide bordersBug
CELLSJAVA-43792Font is incorrect when setting HtmlLoadOptions for HTML to Excel conversionBug
CELLSJAVA-43571DataLabels truncation issue When Converting XLSX to PDFBug
CELLSJAVA-43587Donut chart labels misplacedBug
CELLSJAVA-43620Vertical axis values and point labels are not rendered properly when rendering Excel file (containing Waterfall chart) to HTMLBug
CELLSJAVA-43621Function RANDBETWEEN(bottom, top) value results are different from Excel resultsBug
CELLSJAVA-41710Wrong rendering of HTML after conversion from XLSXBug
CELLSJAVA-43422HTML to Excel conversion - “mso-ignore: padding” in CSS have no effectBug
CELLSJAVA-43606Background text formatting changed while merging filesBug
CELLSJAVA-43769MSO Excel (XLS) document cannot be loadedBug
CELLSJAVA-43527Aspose.Cells for Java NullPointerExceptionException
CELLSJAVA-43506Invalid password exceptionException
CELLSJAVA-43523CellsException for reading shape’s macro name: Invalid formulaException
CELLSJAVA-43565“java.lang.ClassCastException” on reading XLSB file with LightCellsException
CELLSJAVA-43546NullPointerException when extracting series name of chartException
CELLSJAVA-43631Exception “java.lang.NullPointerException” when loading XLSM fileException
CELLSJAVA-43655ArrayIndexOutOfBoundsException with getStringValueException
CELLSJAVA-43788Exception raised while setting value for chart seriesException
CELLSJAVA-43632Exception “Invalid FontUnderlineType string val” when loading an XLSX fileException
CELLSJAVA-43633Exception “Invalid MsoLineDashStyle string val” when loading an XLSX fileException

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 PasteOptions.OperationType property and PasteOperationType enum .

Gets and sets the operation type when pasting range.

Adds PivotFormatCondition.AddColumnAreaCondition(PivotField columnField) method .

Adds PivotTable conditional format limit in the column fields.

Adds PivotFormatCondition.AddColumnAreaCondition(String fieldName) method .

Adds PivotTable conditional format limit in the column fields.

Adds PivotFormatCondition.AddRowAreaCondition(PivotField rowField) method .

Adds PivotTable conditional format limit in the row fields.

Adds PivotFormatCondition.AddRowAreaCondition(String fieldName) method .

Adds PivotTable conditional format limit in the row fields.

Adds PivotFormatCondition.AddDataAreaCondition(PivotField dataField) method .

Adds PivotTable conditional format limit in the data fields.

Adds PivotFormatCondition.AddDataAreaCondition(String fieldName) method .

Adds PivotTable conditional format limit in the data fields.

Adds PivotFormatCondition.SetConditionalAreas() method.

Sets conditional areas of PivotFormatCondition object.

Adds SeriesCollection.Add(boolean,boolean) method.

Adds series with a range.

Adds SetSeriesNames() method.

Sets a range as name of the series.

Adds AbstractInterruptMonitor class.

Provides AbstractInterruptMonitor as the base of implementations for interruption monitor. The InterruptMonitor class now becomes one implementation of it. The type of InterruptMonitor properties for LoadOptions and Workbook now become AbstractInterruptMonitor too so user can use their own implementation to control the time-consuming operations.

Adds HtmlSaveOptions.WorksheetScalable property.

Indicates if zoom in or out the html via worksheet zoom level when saving file to html, the default value is false.

Adds override WorksheetCollection.GetRangeByName() method.

Gets Range object by name from defined names or Tables.

Adds Range.AutoFill() method.

Automatically fills data to the range.

Adds WarningType.IO enum.

Represents the file corrupted warning.

Adds AutoFitterOptions.FormatStrategy property.

Gets and sets the formatted strategy for auto fitting.

Adds MsoFormatPicture.Transparency property.

Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).

Adds overloaded PivotTableCollection.Remove() methods.

Deletes the specified PivotTable and checks whether keeping cells’ data .

Adds ImageOrPrintOptions.IsOptimized property.

Indicates whether optimize the output elements. Default value is false. Currently only the border lines are optimized when this property is set to true.