Aspose.Cells for Android via Java 17.9 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSJAVA-42356 | Add a property to indicate whether to output an empty page or not when there is nothing to print | New Feature |
| CELLSJAVA-42322 | Support Advanced Filter (MS Excel) feature to display records that meet a complex criteria | New Feature |
| CELLSJAVA-42391 | Cell width shown in the resulted PDF is not the same as in the Excel file when using the “Show formula” feature | New Feature |
| CELLSJAVA-42379 | Implementing Named Destination when rendering to PDF output (Bookmark query) | New Feature |
| CELLSJAVA-42336 | ResultSet imports zero instead of null value in XLSX file | Enhancement |
| CELLSJAVA-42321 | CellsHelper.setSignificantDigits() should not be (global) static function | Enhancement |
| CELLSJAVA-42341 | InterruptMonitor takes more time to interrupt the Workbook saving process for a large file having PivotTable | Enhancement |
| CELLSJAVA-42358 | Formula is not displayed in the resulted PDF | Enhancement |
| CELLSJAVA-42351 | WEEKDAY formula returns wrong value on workbook formula calculation | Enhancement |
| CELLSJAVA-42401 | Have to enumerate all shapes to set the Z-Order of the shape properly | Enhancement |
| CELLSJAVA-42368 | Set name of ActiveX Control (ListBox) | Enhancement |
| CELLSJAVA-42308 | PivotTable issues(missing rows, pivot field headers printed twice, Date converted to numeric values, etc.) for HTML rendering | Bug |
| CELLSJAVA-42298 | Extra characters present in HTML output of Excel file | Bug |
| CELLSJAVA-42277 | Image does not get displayed in the output HTML when HtmlSaveOptions.setExportHiddenWorksheet is set to false | Bug |
| CELLSJAVA-42259 | HTML could not be converted to Excel file properly | Bug |
| CELLSJAVA-42256 | Issue with HTML table to Excel rendering | Bug |
| CELLSJAVA-42319 | Issue with calculating Print Area when specifying formulas | Bug |
| CELLSJAVA-42320 | Chart does not get updated if it exists in separate sheet | Bug |
| CELLSJAVA-42295 | Cell value is appended at the start when we click on an existing cell (having some value) | Bug |
| CELLSJAVA-42325 | When XLSX is saved as PDF, the words are mirrored | Bug |
| CELLSJAVA-42299 | Extra characters present in output PDF/image of Excel file | Bug |
| CELLSJAVA-42301 | Bars are missing in Bar chart’s PDF output | Bug |
| CELLSJAVA-42293 | Chart image is wrong in the output HTML | Bug |
| CELLSJAVA-42292 | Image of the chart is incorrect in the output HTML | Bug |
| CELLSJAVA-42270 | Content is missing when Excel Chart is converted to PDF | Bug |
| CELLSJAVA-42258 | Chart’s PDF has wrong date format of x-axis labels | Bug |
| CELLSJAVA-42252 | Incorrect Y-axis scaling in the output PDF | Bug |
| CELLSJAVA-42245 | Style/formatting is wrong when save to HTML | Bug |
| CELLSJAVA-42316 | Option to compress images is not preserved on opening and saving the Excel file | Bug |
| CELLSJAVA-42306 | Background color of cells in File2 gets changed on opening and saving Workbook | Bug |
| CELLSJAVA-42305 | Background color of cells in File1 gets changed on opening and saving Workbook | Bug |
| CELLSJAVA-42303 | Excel formula cell becomes non-formula cell when setting text for the shape | Bug |
| CELLSJAVA-42284 | Workbook.getFonts() shows additional font after reloading the same spreadsheet | Bug |
| CELLSJAVA-42327 | Some shapes are distorted and changed in Excel to PDF rendering | Bug |
| CELLSJAVA-42290 | Mdashes and ndashes inserted into TextBoxes in charts are not rendered properly in chart’s PDF | Bug |
| CELLSJAVA-42338 | Wrong results when using SUMIFS formulas | Bug |
| CELLSJAVA-42337 | Aspose.Cells is unable to calculate the value of cell B4 of Calculations worksheet | Bug |
| CELLSJAVA-42330 | Weird result when converting from Excel to PDF or PDF/A using threads | Bug |
| CELLSJAVA-42331 | Changes to comment author field are not preserved | Bug |
| CELLSJAVA-42328 | Wrong IconSet returned | Bug |
| CELLSJAVA-42324 | Chart’s background is missing after setting a picture’s data | Bug |
| CELLSJAVA-42332 | Aspose.Cells is not able to convert the HTML file correctly while MS-Excel is able to convert it properly | Bug |
| CELLSJAVA-42355 | For Number 39 MS Excel formats negative value with ‘-’ instead of ‘()’ for Italy | Bug |
| CELLSJAVA-42350 | Label text is displaced for the Pie chart | Bug |
| CELLSJAVA-42343 | Various styles of the Waterfall chart don’t render properly. | Bug |
| CELLSJAVA-42342 | The Waterfall chart always shows connection lines | Bug |
| CELLSJAVA-42352 | Shape is not updated with correct value | Bug |
| CELLSJAVA-42349 | Excel to PDF conversion hanged for an XLSX file | Bug |
| CELLSJAVA-42348 | Unable to import XLSB file (by Aspose.Cells APIs) into MS-Access database | Bug |
| CELLSJAVA-42369 | HTML output of Excel document contains hash values instead of actual values | Bug |
| CELLSJAVA-42366 | Saving “2.2 CompleteEmail.html” to Xlsx format generates corrupt file | Bug |
| CELLSJAVA-42365 | Loading “2.1 CompleteEmail.html” in Workbook object throws NullPointerException | Bug |
| CELLSJAVA-42381 | Workbook Calculation is wrong for Lookup Excel formula | Bug |
| CELLSJAVA-42380 | Array formula in the sheet is calculated differently via Aspose.Cells | Bug |
| CELLSJAVA-42370 | Incorrect Hyperlinks and PDF content | Bug |
| CELLSJAVA-42395 | Rendering - Chart image is not correct | Bug |
| CELLSJAVA-42393 | Category axis labels are missing when converting Excel to Pdf | Bug |
| CELLSJAVA-42384 | Color of Negative Bars is not correct when Excel is converted to Pdf | Bug |
| CELLSJAVA-42378 | Bar color changed while converting Excel to PDF when using setCrossAt() | Bug |
| CELLSJAVA-42377 | Value of major units of axis in the chart is returned wrong | Bug |
| CELLSJAVA-42364 | Datalabels from cell range are not coming when exported to Pdf | Bug |
| CELLSJAVA-42359 | Missing Datalabels for a Series which is having Bar Values as 100 | Bug |
| CELLSJAVA-42314 | Chart is Blank in the output PNG | Bug |
| CELLSJAVA-42313 | Chart is Blank in the output PDF | Bug |
| CELLSJAVA-42374 | Character references parsed incorrectly by Aspose Cells | Bug |
| CELLSJAVA-42373 | Copying workbook and then saving corrupts the output Excel file | Bug |
| CELLSJAVA-42392 | Exception “com.aspose.cells.CellsException: unknown excel content!” on instantiating an encrypted Excel file | Exception |
| CELLSJAVA-42307 | Exception: “The row index should not be inside the pivottable report” occurred when rendering to HTML file format | Exception |
| CELLSJAVA-42285 | Exception: “Row index cannot be negative” occurred if a PivotTable exists in the worksheet to be converted to HTML file format | Exception |
| CELLSJAVA-42318 | An exception is thrown when trying to open Workbook | Exception |
| CELLSJAVA-42311 | Exception: “java.lang.NullPointerException” when opening an ODS file via Aspose.Cells APIs | Exception |
| CELLSJAVA-42302 | NullPointerException on creating Workbook instance from source Excel file | Exception |
| CELLSJAVA-42340 | Exception in thread “Thread-2” java.lang.OutOfMemoryError: GC overhead limit exceeded | Exception |
| CELLSJAVA-42334 | Exception “Error for ZipFile” is thrown when using OutputFileStream | Exception |
| CELLSJAVA-42326 | com.aspose.cells.CellsException: Invalid password on opening the Excel file | Exception |
| CELLSJAVA-42357 | Exception occurs when saving an Excel file into HTML format | 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 Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
Adds enum StyleModifyFlag.RelativeIndent
Represents relative indent.
Adds TextureFill.IsTiling property
Indicates whether tile picture as texture.
Adds GlobalizationSettings.GetBooleanValueString()/GetErrorValueString() methods
Gets custom display string value for cell’s Boolean and error value when formatting/rendering.
Removes obsoleted ValidationCollection.Add() method
Use ValidationCollection.Add(CellArea) method instead.
Adds PdfSaveOptions.CheckWorkbookDefaultFont property
Indicates whether to try to use workbook’s default font firstly to show the characters which font is not set correctly.
Adds ImageOrPrintOptions.CheckWorkbookDefaultFont property
Indicates whether to try to use workbook’s default font firstly to show the characters which font is not set correctly.
Adds FileFormatType.Numbers, LoadFormat.Numbers and SaveFormat.Numbers enum
Represents the Numbers spreadsheet file format by Apple Inc/.
Adds Worksheet.AdvancedFilter() method
Filters data using complex criteria.
Adds WorkbookSettings.SignificantDigits property
Gets and sets the number of significant digits.
Obsoletes Validation.AreaList property and adds Validation.Areas property
Gets all area which contains the data validation settings.
Adds PageSetup.IsAutomaticPaperSize property
Indicates whether the paper size is automatic.
Adds FontSettingCollection.Replace() method
Replaces the text of the shape.
Adds Cells.importResultSet(ResultSet rs, int rowIndex, int columnIndex, ImportTableOptions options)/Cells.importResultSet(ResultSet rs, String startCell, ImportTableOptions options)
Supports importing ResultSet with more options.
Adds HtmlSaveOptions.IsExportComments property
Indicates if exporting comments when saving file to HTML, the default value is false.
Adds HtmlSaveOptions.DisableDownlevelRevealedComments property
Indicates if disable Downlevel-revealed conditional comments when exporting file to HTML, the default value is false.
Adds CustomImplementationFactory class
Provides API for the user to extend/improve the component’s ability by some special implementations for some special situations. Currently there is no custom implementation supported for Java version.
Adds CellsHelper.CustomImplementationFactory property
Gets/sets the CustomImplementationFactory instance used by cells component.
Adds Workbook.AddDigitalSignature(DigitalSignatureCollection digitalSignatureCollection) method
Adds digital signature to an already signed OOXML spreadsheet file (Excel2007 and later).
Adds ImageOrPrintOptions.OutputBlankPageWhenNothingToPrint property
Indicates whether to output a blank page when there is nothing to print.
Adds HTMLLoadOptions.LoadStyleStrategy property
Indicates the strategy to apply style for parsed values when converting string value to number or DateTime.
Adds class AbstractCalculationMonitor
Provides APIs for users to monitor the progress of formula calculation.
Adds CalculationOptions.CalculationMonitor property
Allows user to provide custom implementation to monitor the progress of formula calculation.
Adds enum GridlineType
Enumerates gridline Type.
Adds ImageOrPrintOptions.GridlineType property
Gets or sets gridline type.
Adds PdfSaveOptions.GridlineType property
Gets or sets gridline type.
Adds Name.GetRanges(bool) and Name.GetRange(bool) methods
For simple Name objects mostly, such as, named ranges with absolute references, the name’s reference needs not to be calculated repeatedly. So GetRanges(false)/GetRange(false) will not re-calculate the Name object when getting corresponding range(s) and so the the performance may be improved significantly if those methods are called repeatedly.
Adds PdfBookmarkEntry.DestinationName property
Gets or sets name of destination. If desitnation name is set, the desitnation will be defined as a named destination with this name.
Adds DataSorter.AddKey() method
Adds sorted column index and sort order with custom sort list.
Adds Picture.Copy() method
Copies settings from other picture.
Adds Shape.ToFrontOrBack() method
Brings the shape to front or sends it to the back.
Adds enum ConnectionDataSourceType.Table
Represents the table as the data source of the connection.
Adds PageSetup.SetFitToPages() method
Sets the number of pages the worksheet will be scaled to when it’s printed.
Adds PdfSaveOptions.StreamProvider property and ResourceLoadingType enum
Gets and sets the type of loading external resource.
Adds VbaModuleCollection.AddDesignerStorage() and GetDesignerStorage() methods
Gets and sets the designer storage of the VBA project.