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.