Aspose.Cells for Android via Java 23.9 Release Notes

CELLSJAVA-45554Lost spacing in formula after savingNew Feature
CELLSJAVA-42866Get button name and title in ODS fileNew Feature
CELLSJAVA-44907Evaluate and enhance rendering HTML to Excel worksheetsEnhancement
CELLSJAVA-45584Parsing xml with unescaped greater than signEnhancement
CELLSJAVA-45440Shapes with contents are not rendered precisely in Excel to PDF conversionBug
CELLSJAVA-45473EXCEL function TRIM() calculation errorBug
CELLSJAVA-45475Inexplicable change in the handling of numbers in right functionBug
CELLSJAVA-45027Overlapping Labels issue in Donut ChartsBug
CELLSJAVA-45102Issue with graph rendering - “+” sign and graph for both the x-axis and y-axis are not being plotted in the output PDFBug
CELLSJAVA-45398Position of legends is not retained during chart conversion to imageBug
CELLSJAVA-45396Position of leader lines is not retained during chart conversion to imageBug
CELLSJAVA-45399Font size of legends is not retained during chart conversion to imageBug
CELLSJAVA-45409Horizontal (Category) Axis missing in rendered PDF Charts from Excel chartBug
CELLSJAVA-45419Chart to Image - string split into two linesBug
CELLSJAVA-45423Excel Chart into image (.jpeg) : wrong exportBug
CELLSJAVA-45459Cell references are not displayed correctly when converting PDF in ExcelBug
CELLSJAVA-45478XLSX to PNG: Scale of Y-Axis wrongBug
CELLSJAVA-45480X-axis of graph is too long in Excel to PDF renderingBug
CELLSJAVA-45456Incorrect rendering of torus in topdf(.net /java)Bug
CELLSJAVA-45471The horizontal and vertical resolution is not set in Tiff while converting to Tiff image in JDK9Bug
CELLSJAVA-45469Text offset issue when saving file to HTMLBug
CELLSJAVA-45487Alignment Issue while loading HTML into Excel fileBug
CELLSJAVA-45486Special characters appear while converting spreadsheetML to xlsxBug
CELLSJAVA-45481Axis labels are rendered as vertical which should be diagonalBug
CELLSJAVA-45485Waterfall chart to image lines appearBug
CELLSJAVA-45514Regression: Slow performance of Workbook CalculateFormulaBug
CELLSJAVA-45531YEARFRAC formula calculation errorBug
CELLSJAVA-44882Chart to image rendering - One of the labels is inside the doughnut chartBug
CELLSJAVA-45508Some labels overlapped when rendering chart to SVG/PDF on linuxBug
CELLSJAVA-45524Missing values on x-axis on bar chart compared to original Excel fileBug
CELLSJAVA-45548Y-axis scale of the bar chart changed when saving workbook to HTMLBug
CELLSJAVA-45536Office PowerPoint reports an error while saving pptx(inserted a generated Emf image) to pdfBug
CELLSJAVA-45542Failed to set transparency to false when saving as SVGBug
CELLSJAVA-45470Conditional formatting with Data Bars are rendered incorrectly in HTML exportBug
CELLSJAVA-45507The issue with HTML extracted from the XLSX fileBug
CELLSJAVA-45521Horizontal Shifting not working using Smart Markers optionBug
CELLSJAVA-45544Output XLSX file does not show contents/values correctly after re-saving the fileBug
CELLSJAVA-45546Pictures are damaged after saving xls to xlsxBug
CELLSJAVA-45551Characters disappear when saving file to pdfBug
CELLSJAVA-45557Shapes are lost in Excel to PDF renderingBug
CELLSJAVA-45583YEARFRAC is not working as in Excel in Aspose Cells for Java 23.8Bug
CELLSJAVA-45592Regression: Worksheet not calculatedBug
CELLSJAVA-42279Labels of Chart are overlapping having missing lines when Chart is converted to PdfBug
CELLSJAVA-44175issue with overlapping Donut Chart LabelsBug
CELLSJAVA-45575Legend data of chart error when saving to imageBug
CELLSJAVA-45593The underline style of the chart title is incorrect when converting the file to HTMLBug
CELLSJAVA-45568Overlapping and garbled date data when saving files to svgBug
CELLSJAVA-45600Cells text not center aligned vertically in the generated EMF imageBug
CELLSJAVA-45261The texts are truncated when converted to HTMLBug
CELLSJAVA-45538Content of some cells not fully displayed within the width of the column when printed to HTMLBug
CELLSJAVA-45550Some cells in rows are shifted to the right in Excel to HTML renderingBug
CELLSJAVA-45582Extra underline appears in the text when converting the file to HTMLBug
CELLSJAVA-45555Issue with rendering some Excel 3-D charts (Column and Pie) into PDFBug
CELLSJAVA-45573Pivot table wrong background colors in converted PDFBug
CELLSJAVA-45596File corrupted after PivotTable.refreshData()Bug
CELLSJAVA-45491Memory overflow when converting xls to xlsxException
CELLSJAVA-45489Exceptions occur when converting xlsx to xlsException
CELLSJAVA-45504Shape to image error when converting file to pdfException
CELLSJAVA-45519“java.lang.OutOfMemoryError” while converting XLS to XLSXException
CELLSJAVA-45513Exception “java.lang.IllegalArgumentException” when loading an XLSX fileException
CELLSJAVA-45556Exception using CellsHelper.convertR1C1FormulaToA1 when there are characters R or C or RC in formulasException

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.

Changes behavior of setting Cells.StandardWidth

In old versions, setting standard width for worksheet does not change the width of those columns whose width is defined by default column. This caused inconsistent result when changing the sequence of setting standard width and applying row style. From 23.7, we make the width of default columns change to keep same with the new standard width when user setting this property.

Obsolete FileFormatType.Numbers enum

Please use FileFormatType.Numbers09 instead.

Adds FileFormatType.MicrosoftCabinet and FileFormatType.Rtf enum

Used for detecting file format type.

Adds method Shape.GetActualBox()

Gets the actual position and size of the shape (after applying rotation, flip, etc.)

Adds XmlLoadOptions.ConvertNumericOrDate, XmlLoadOptions.NumberFormat and XmlLoadOptions.DateFormat properties

Represents the options of converting numberic text.

Adds XmlLoadOptions.IgnoreRootAttributes property

Indicates whether ignore the attributes of xml root element.

Adds FormulaSettings.PreservePaddingSpaces property

Indicates whether to preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas.

Adds LoadOptions.PreservePaddingSpacesInFormula property

Indicates whether to preserve those spaces and line breaks that are padded between formula tokens while parsing formulas that imported from template file.

Adds Cells.DeleteRow(int rowIndex, bool updateReference) method

One override method for deleting row with specified flag of updating references.

Adds AbstractCalculationEngine.IsParamArrayModeRequired property and CalculationData.GetParamValueInArrayMode(int index, int maxRowCount, int maxColumnCount) method

Provides those apis for user’s special requirement of getting parameter’s values in array mode while calculating custom functions.

Adds Cell.InsertText() method

Inserts text to the cell.

Adds Cell.Replace() method.

Replaces text of the cell with options.

Adds ReplaceOptions.FontSettings options.

Replaces the old text with rich formatting text.

Adds HtmlSaveOptions.IsIECompatible property.

Indicates whether the output HTML is compatible with IE browser.

Adds CustomFunctionDefinition class

The abstract class to support user to specify some special settings for custom functions by implementing it.

Adds Workbook.UpdateCustomFunctionDefinition(CustomFunctionDefinition definition) method

Supports to update all formulas which reference to custom functions according to user’s custom definition for them.

Adds FormulaParseOptions.CustomFunctionDefinition property

Supports to parse formula with user’s custom definition for custom functions.

Adds overloaded Worksheet.CalculateFormula(…) method

Supports to parse and calculate given formula with custom options and other conditions.

Adds overloaded Worksheet.CalculateArrayFormula(…) method

Supports to parse and calculate given formula as array formula with custom options and other conditions.

Adds Worksheet.ConvertFormulaReferenceStyle(string formula, bool toR1C1, int baseCellRow, int baseCellColumn) method

Converts the reference style between R1C1 and A1 for the given formula.

Adds CellValue class

Represents the cell value and corresponding type.

Adds virtual method ExportTableOptions.PreprocessExportedValue(int cellRow, int cellColumn, CellValue value)

Provides user the ability of checking and replacing some special cell types and values when exporting.

Adds Dispose() method for SheetRender and WorkbookRender

Provides user the ability to explicitly release resources created during rendering.

Adds EbookLoadOptions and EbookSaveOptions class

Represents options when importing/exporting an ebook file.

Adds GridWeb.DPI property

Gets and Sets the DPI of the machine.

Adds FileFormatType.Epub, LoadFormat.Epub, SaveFormat.Epub enum

Represents an EPUB file.

Adds Chart.FilteredNSeries property

Represents the data series collection that are not selected in the chart.

Adds Series.IsFiltered  property

Supports to filter the series in the chart. True represents this series is filtered, and it will not be displayed on the chart.

Adds CommentTitleType.Note and Reply enum type

Represents comment title note and reply.

Obsolete CellsHelper.ConvertR1C1FormulaToA1()/ConvertA1FormulaToR1C1() methods

Please use Worksheet.ConvertFormulaReferenceStyle() method instead.

Obsolete PdfSecurityOptions.ExtractContentPermissionObsolete property

Please use PdfSecurityOptions.ExtractContentPermission property instead.

Adds TableStyleCollection.DefaultTableStyleName and TableStyleCollection.DefaultPivotStyleName properties.

Gets and sets the default style name of the table and pivot.

Adds WorksheetCollection.RefreshAll() method.

Refreshes all Pivottables and Pivot Charts.

Adds Validation.GetValue() mthod.

Gets the result of validation in the cell.