Aspose.Cells for Android via Java 23.3 Release Notes

CELLSJAVA-44172Support interruption while calculating formulas for one cellNew Feature
CELLSJAVA-45029Support the sheet zoom, freeze panes when exporting and importing htmlNew Feature
CELLSJAVA-45149Modify the logic of generating a ‘group’ object from the smartart objectNew Feature
CELLSJAVA-45034How to code/utilize Row 1 Filter Flag OptionEnhancement
CELLSJAVA-43438Fill <Application> tag in XLSXEnhancement
CELLSJAVA-45119When reading into 03 format excel, the ‘FillType’ of the straight line is not processedEnhancement
CELLSJAVA-45128Horizontal flip seems to be missing when reading arrow linesEnhancement
CELLSJAVA-45172Support loadoption for GridWebEnhancement
CELLSJAVA-45173Support margins of img tag when loading htmlEnhancement
CELLSJAVA-45003XLS to HTML: Rectangle shape is distortedBug
CELLSJAVA-45004XLS to HTML: Image clipped and moved out of placeBug
CELLSJAVA-44364Difference in values between an Excel file and the converted PDF (via Aspose.Cells) fileBug
CELLSJAVA-45026Double quotes " from XLSX file not shown in converted PDF fileBug
CELLSJAVA-45035DATEDIF function doesn’t work correctly with leap yearsBug
CELLSJAVA-45008Chart legend items cut off in the output imageBug
CELLSJAVA-45036Regression: Chart resized incorrectlyBug
CELLSJAVA-45017can not switch worksheet in java demo project for the file with passwordBug
CELLSJAVA-44942Colors lost when exporting a Chart to EMFBug
CELLSJAVA-45005Font with font full name is not picked while converting to pdfBug
CELLSJAVA-45033Worksheet to Emf image is not right after setting resolution optionBug
CELLSJAVA-44971Images cannot display when loading html streamBug
CELLSJAVA-45020HTML to EXCEL: Styles changedBug
CELLSJAVA-45062XLS to HTML: Arrow shiftingBug
CELLSJAVA-45085Diagram scattered issue in Excel to PDF renderingBug
CELLSJAVA-45118Incomplete shape display after rotation when save to pdfBug
CELLSJAVA-45088Displayed result is incorrect for resultant html when cell value is string with custom formatBug
CELLSJAVA-45094Global named ranges with references like =!$K$23 break in the new versionBug
CELLSJAVA-45115Method deleteRows is causing incorrect formattingBug
CELLSJAVA-45077The saved file reports an error when upload and open in Onedrive diskBug
CELLSJAVA-45109An Exception is thrown when converting chart to imageBug
CELLSJAVA-45112Render special Major Gridline for Radar ChartBug
CELLSJAVA-45103Colored pictures inserted in excel become black when converted to pdfBug
CELLSJAVA-45155Center Across text is cut off if it is in the last column when converting to pdfBug
CELLSJAVA-45160HTML to EXCEL convert failed with error Invalid #Bug
CELLSJAVA-45079Custom Number Format with Trailing Dots is ignored when exporting to HTMLBug
CELLSJAVA-45084Font changed in the re-saved xls fileBug
CELLSJAVA-45106The result file is abnormal when converting excel to htmlBug
CELLSJAVA-45117Shape rotate error when save to htmlBug
CELLSJAVA-45123Arc shape should be flipped Horizontally of Excel 95Bug
CELLSJAVA-45132Support pattern fill of shape in the Excel95/5.0Bug
CELLSJAVA-45147Some text in the last column are cut off when saving file to htmlBug
CELLSJAVA-45148Merged areas lost after saving as htmlBug
CELLSJAVA-45087The border is displayed on the text for the chart title in Excel to PDF renderingBug
CELLSJAVA-45110Converted image is not same as MS Excel.Bug
CELLSJAVA-45190Calculated field values are not retrieved by the getCalculatedValue() function.Bug
CELLSJAVA-45056Chart to Image - character and legend height not rendered correctlyBug
CELLSJAVA-45089Converted PDF is showing diagram labels at different location and incorrect Axis pointsBug
CELLSJAVA-45141Data labels missing from chart in copied workbook in v23Bug
CELLSJAVA-45178When converting xlsx to html, the program will prompt that the starting cell of the Chart object has invalid ‘}’ contentBug
CELLSJAVA-45195Series Line is missing in a Scatter chartBug
CELLSJAVA-45054Can not switch worksheet for the specified file from customerBug
CELLSJAVA-45143CSV file not same with WPS fileBug
CELLSJAVA-45072The converted PDF by Aspose.Cells from MS Excel file could not be read normally with iTextBug
CELLSJAVA-45200Showing “#” for numbers in the converted PDFBug
CELLSJAVA-45159Text is not center aligned while rendering to png imageBug
CELLSJAVA-41794HTML is wrong when some rows are hiddenBug
CELLSJAVA-45189Select pivot data field of a pivot table to apply format onBug
CELLSJAVA-45197Formatting issues in HTML to Excel conversionBug
CELLSJAVA-45021“com.aspose.cells.CellsException: Invalid sheet reference for the defined Name” when rendering an Excel file to PDFException
CELLSJAVA-45025ArrayIndexOutOfBoundsException on workbook saveException
CELLSJAVA-45051Password not working when opening LibreOffice Calc file (ODS)Exception
CELLSJAVA-44070Exception “Invalid end row index” in CSV to PDF renderingException
CELLSJAVA-45107An exception IllegalArgumentException is generated when exporting files to htmlException

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 PivotGlobalizationSettings class.

The class manages all globalization settings about pivot table.

Removes GlobalizationSettings.GetOtherName() method.

This method has not been referenced any more, it takes no effect even user implements it in GlobalizationSettings. So we remove it now. User should use ChartGlobalizationSettings.GetOtherName() method instead.

Removes GlobalizationSettings.GetColumnLablesName()/GetRowLablesName() methods.

Please use PivotGlobalizationSettings.GetTextOfColumnLabels()/GetTextOfRowLabels().

Obsoletes all methods about pivot table in GlobalizationSettings.

Please use corresponding methods in PivotGlobalizationSettings.

Adds SetStyle() method for Row and Column class.

Supports to set custom style for the whole Row/Column. For setting custom style, the difference between SetStyle() and ApplyStyle() is that SetStyle() does not change the style settings for existing cells.

Adds HasCustomStyle property for Cell, Row and Column classes.

Indicates whether the cell, row or column has been set with custom style settings(different from the default one it inherits).

Adds JsonSaveOptions.AlwaysExportAsJsonObject property.

Indicates whether always export Excel files as Json object even if there is only one worksheet.

Adds RevisionHeader class and RevisionLog.MetadataTable property.

Supports getting and setting properties of revision log.

Adds Style.GetTwoColorGradientSetting() method and obsoletes Style.GetTwoColorGradient() method.

Use Style.GetTwoColorGradientSetting() method instead.

Obsoletes JsonUtility.ExportRangeToJson(Range,ExportRangeToJsonOptions) and adds JsonUtility.ExportRangeToJson(Range, JsonSaveOptions)

Use ExportRangeToJson(Range, JsonSaveOptions) method instead.

Adds Charts.Axis.CustomUnit property.

Specifies a custom value for the display unit.

Obsoletes Charts.Axis.CustUnit property.

Please use Charts.Axis.CustomUnit instead.

Adds Charts.Chart.PlotVisibleCellsOnly property.

Indicates whether plot visible cells only.

Obsoletes Charts.Chart.PlotVisibleCells property.

Please use Charts.Chart.PlotVisibleCellsOnly instead.

Removes ShapeFormat.FillFormat property.

Please use ShapeFormat.Fill property instead.

Removes ShapeFormat.Outline property.

Please use ShapeFormat.Line property instead.

Adds ChartTextFrame.IsAutomaticRotation property

Indicates whether the text of the chart is automatically rotated.

Obsoletes JsonLayoutOptions.IgnoreObjectTitle and JsonLayoutOptions.IgnoreArrayTitle properties

Please use JsonLayoutOptions.IgnoreTitle property instead.

Adds JsonLayoutOptions.IgnoreTitle property

Ingores titles of Json attributes when converting json to Excel.

Adds Style.ToJson() method

Converts style of Excel files to json file

Adds Cell.ToJson() method

Converts a cell of cells to json file.

Adds CalculationOptions.LinkedDataSources property

Allows user to set linked data sources for external links used in formula for calculation.

Obsoletes SvgSaveOptions class

Please use ImageSaveOptions class instead.

Obsoletes SvgSaveOptions() constructor

Please use ImageSaveOptions(SaveFormat.Svg) instead and set ImageSaveOptions.ImageOrPrintOptions.OnePagePerSheet to true.

Obsoletes SvgSaveOptions.SheetIndex property

Please use ImageSaveOptions.ImageOrPrintOptions.SheetSet instead.

Adds StyleModifyFlag.FontVerticalText enum

Indicates whether text is vertical aligned.

Adds WarningType.InvalidOperator enum

Represents the invalid operator of warning when operating Excel files.

Supports setting Row.GroupLevel and Column.GroupLevel properties

Supports setting group level of rows and columns.

Obsoletes HtmlLoadOptions.ConvertFormulasData and adds HtmlLoadOptions.HasFormula properties

Please use HtmlLoadOptions.HasFormula instead.

Obsoletes PivotGlobalizationSettings.GetTextOfProtection() and adds PivotGlobalizationSettings.GetTextOfProtectedName(String) methods

Please use PivotGlobalizationSettings.GetTextOfProtectedName(String) instead.

Adds Chart.IsReferedByChart(Int32,Int32) method

Indicates whether this cell is refered by the chart.

Adds PasteOptions.IgnoreLinksToOriginalFile property

Do not link to the original file when copying range.

Adds PivotArea,PivotTableSelectionType and PivotTable.Format(Pivot.PivotArea,Style)

Select the area and format it of the PivotTable.

Adds SheetSet.Active property

Gets a set with active sheet of the workbook.