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