Aspose.Cells for Android via Java 8.9.0 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSJAVA-41664 | Exporting DataBars based on Conditional Formatting to HTML | New Feature |
| CELLSJAVA-40746 | Support ColorScale, DataBar, IconSet while exporting XLSX to HTML | New Feature |
| CELLSJAVA-41820 | Worksheet has no method calcualteFormula(String formula, CalculationOptions options) | New Feature |
| CELLSJAVA-40544 | Performance bottleneck on Workbook.calculateFormula | Enhancement |
| CELLSJAVA-41817 | Setting ShowAllItems for PivotField does not seem to take effect | Bug |
| CELLSJAVA-41810 | Text is getting congested and overlapping in the EMF image | Bug |
| CELLSJAVA-41801 | Text labels are overlapping in the EMF image | Bug |
| CELLSJAVA-41834 | Exception is thrown on copying workbook | Bug |
| CELLSJAVA-41819 | Spreadsheet to HTML: Alignment of Text in a Shape is wrong after copying theme from source spreadsheet | Bug |
| CELLSJAVA-41824 | Graph is not rendered in the output PDF | Bug |
| CELLSJAVA-41805 | X-axis labels missing in Chart’s PDF | Bug |
| CELLSJAVA-41767 | Incorrect number-format of X-axis labels in Chart’s PDF | Bug |
| CELLSJAVA-41640 | Long hyphens don’t display appropriately in the output PDF/Image for the chart | Bug |
| CELLSJAVA-41604 | Horizontal Grid-Lines of chart are not appearing properly in PDF | Bug |
| CELLSJAVA-41832 | Few chart bars are missing while rendering worksheet to image | Bug |
| CELLSJAVA-41837 | Add Chart.toPDF(java.io.OutputStream, com.aspose.cells.PdfSaveOptions) | Bug |
| CELLSJAVA-41839 | A named range is created when Cells.copyRow() method is used within a named range | Bug |
| CELLSJAVA-41838 | When applying autoSizeColumns on the sheet, the column is not widened properly | Bug |
| CELLSJAVA-41835 | CellsException while saving spreadsheet to PDF | Exception |
| CELLSJAVA-41826 | NaN Exception | Exception |
| CELLSJAVA-41848 | Certain data labels are missing while rendering chart to image | Bug |
| CELLSJAVA-41850 | CellsException: Cell has been removed: D9 with MemorySetting.MEMORY_PREFERENCE | Exception |
| CELLSJAVA-41844 | Exception: “Shape to image Error !” when rendering a worksheet to image | Exception |
| CELLSJAVA-41866 | How to set Legend Entry Properties for Text Options | New Feature |
| CELLSJAVA-41865 | Create TextBox in which each line is having different Horizontal Alignment | New Feature |
| CELLSJAVA-41873 | Conversion to HTML renders redundant empty rows | Bug |
| CELLSJAVA-41869 | Text alignment is changed after re-saving a template XLS file | Bug |
| CELLSJAVA-41854 | Excel file with DataBars not converted to HTML properly | Bug |
| CELLSJAVA-41851 | Pivot Chart created with Aspose.Cells does not display in Excel 2016 for MAC | Bug |
| CELLSJAVA-41840 | Aspose.Cells appends null at the end of the path for resources HTML | Bug |
| CELLSJAVA-41878 | LightCells APIs only generates events for the first column of the row | Bug |
| CELLSJAVA-41859 | Cell borders appear after resaving XLS | Bug |
| CELLSJAVA-41888 | Logo image is lost while converting XLS to PDF | Bug |
| CELLSJAVA-41874 | Character position is different in the rendered PDF from an XLS file | Bug |
| CELLSJAVA-41852 | Text overlapping when worksheet is converted to EMF on Linux | Bug |
| CELLSJAVA-41823 | Text density and line breaks are different as compared to Excel generated PDF | Bug |
| CELLSJAVA-41822 | Text is getting trimmed and overlapped while rendering spreadsheet to PDF | Bug |
| CELLSJAVA-41856 | Problems rendering chart to PDF | Bug |
| CELLSJAVA-41855 | Opening and saving the Excel file changes the trend lines | Bug |
| CELLSJAVA-41890 | Workbook save twice, the content saved second time will be different from the first time | Bug |
| CELLSJAVA-41884 | Issue with PageBreaks which are not sorted before saving to Excel file | Bug |
| CELLSJAVA-41876 | File corrupt if opened, saved, re-opened and saved by Aspose.Cells APIs | Bug |
| CELLSJAVA-41867 | Chart axis values changed after re-saving an XLS file | Bug |
| CELLSJAVA-41861 | NullReferenceException while loading an Excel XLS file | Bug |
| CELLSJAVA-41298 | Not getting accurate information about WordArt shape formatting from Aspose.Cells APIs | Bug |
| CELLSJAVA-40366 | Issue with embedded icon - not printing | Bug |
| CELLSJAVA-41883 | CellsException: Unknown add-in function type: 9, at Workbook.calculateFormula | Exception |
| CELLSJAVA-41858 | CellsException: Error in calculating Cell[0BMW CAN Bus Codes V0.4!R4], at Workbook.calculateFormula | Exception |
| CELLSJAVA-41870 | java.lang.ArrayIndexOutOfBoundsException: 4 at Workbook.save while re-saving XLS | Exception |
| CELLSJAVA-41864 | Exception: java.lang.IllegalStateException: Invalid encoding: null on re-saving an XLS file | Exception |
| CELLSJAVA-41901 | Bars are moving upward in the output PDF | Enhancement |
| CELLSJAVA-41909 | Specifying Custom Number Decimal and Group Separators for Workbook doesn’t work | Bug |
| CELLSJAVA-41895 | Formula calculation result differs from Excel native calculation | Bug |
| CELLSJAVA-41917 | Checkboxes are not rendering correctly when using SheetRender.toImage() method | Bug |
| CELLSJAVA-41903 | Character orientation is different while rendering to PDF | Bug |
| CELLSJAVA-41896 | Some characters are missing or not pasted right in Excel to PDF conversion | Bug |
| CELLSJAVA-41740 | Some of the DataBar images are blank | Bug |
| CELLSJAVA-41769 | Bars of the graph not aligned properly with cells in PDF | Bug |
| CELLSJAVA-41905 | Misaligned bars after rendering spreadsheet to EMF | Bug |
| CELLSJAVA-41894 | Character spaces problem while rendering spreadsheet to PDF | Bugs |
| CELLSJAVA-41893 | Background image is distorted or blurry in the output PDF | Bug |
| CELLSJAVA-41892 | Background image is stretched in output PDF | Bug |
| CELLSJAVA-41916 | Broken external formula references while using Cells.copyColumns | Bug |
| CELLSJAVA-41915 | Corrupted XLSX file after text replace | Bug |
| CELLSJAVA-41912 | Problem with removeFormula on a spreadsheet referencing Named Ranges | Bug |
| CELLSJAVA-41899 | Cannot detect XLSX load format with FileFormatUtil.detectFileFormat | Bug |
| CELLSJAVA-41328 | Loss of text block in frenchCommonWords.xlsx | Bug |
| CELLSJAVA-40307 | Text Overflow check | Bug |
| CELLSJAVA-41919 | CellsException: 2"=“Stra?e zu breit”,", at Workbook ctor | Exception |
| CELLSJAVA-41914 | java.lang.ArrayIndexOutOfBoundsException: 4 while getting font of cell | Exception |
| CELLSJAVA-41920 | StringIndexOutOfBoundsException: String index out of range: 7, while exporting chart to image | Exception |
| CELLSJAVA-41913 | Exception: “IllegalArgumentException: length” on loading an Excel (XLS) file | Exception |
| CELLSJAVA-41911 | Exception: “Error in Cell: … -Invalid formula” while loading an Excel file via Aspose.Cells APIs | Exception |
| CELLSJAVA-41906 | Workbook constructor throws Exception: “java.lang.NumberFormatException: empty String” | 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. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
Adds WorkbookSetting.PaperSize property.
It’s used to set paper size of the default printer as default paper size of the workbook.
Adds LoadDataFilterOptions class and LoadOptions.LoadDataFilterOptions property
It’s used to specify what kind of data should be loaded when building the workbook from template file. Filtering loaded data can improve the performance for user’s special purpose, especially when using LightCells APIs.
Adds Worksheet.CalculateFormula(string formula, CalculationOptions opts) method
It’s used to calculate given formula directly with user’s custom options.
Obsoleted Shape.TextFrame property.
Use Shape.TextBody.TextAlignment property instead.
Adds Shape.TextBody property.
Presents the setting of the shape’s text.
Adds DeleteOptions class
Represents the setting of deleting rows/columns.
Adds override Cells.DeleteBlankColumns(DeleteOptions options) and Cells.DeleteBlankColumns(DeleteOptions options) method.
Deletes blank rows or columns with setting.
Adds Cell.GetCharacters(flag) method
Returns all Characters objects.
Adds OleObject.AutoLoad property
Specifies whether the host application for the embedded object shall be called to load the object data automatically when the parent workbook is opened.
Adds HTMLLoadOptions.SupportDivTag property
Indicates whether support the layout of
Adds HtmlSaveOptions.ExportGridLines property
Indicating whether export the grid lines.The default value is false.
Adds ShapeTextAlignment.TextShapeType property
Specifies the preset geometry that will be used for a shape warp on a piece of text.
Adds LoadOptions.SetPaperSize(PaperSizeType type) method
Sets the default print paper size from default printer’s setting.
Deletes obsoleted Workbook.Decrypt() method.
Please set the WorkbookSettings.Password as null.
Adds ListObject.Comment property.
Gets and sets the comment of the table.
Adds ShapeCollection.AddActiveXControl() method.
Adds ActiveX control.
Adds HTMLLoadOptions.DefaultFontName property
Specifies the default font name for exporting HTML, the default font will be used when the font of style does not exist. If this property is null, Aspose.Cells will use universal font which has the same family with the original font, the default value is null.
Adds PivotTable.IsExcel2003Compatible property
Specifies whether the PivotTable is compatible with Excel2003 when refreshing PivotTable. If true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. If false, a string will not have the aforementioned restriction.The default value is true.
Adds ImageOrPrintOptions.DefaultFont property
When characters in the Excel are unicode and not to be set with correct font in cell style, they may appear as block in pdf,image. Set the DefaultFont such as MingLiu or MS Gothic to show these characters. If this property is not set, Aspose.Cells will use System default font to show these unicode characters.