Aspose.Cells for Java 17.7 Release Notes

CELLSJAVA-42322Support Advanced Filter (MS Excel) feature to display records that meet a complex criteriaNew Feature 
CELLSJAVA-42336ResultSet imports zero instead of null value in XLSX fileEnhancement 
CELLSJAVA-42329Enhancements needed for data filters and paging features - Aspose.Cells.GridWeb (Java) Enhancement 
CELLSJAVA-41616SaveCustomStyleFile is not present in GridWeb (Java) Enhancement 
CELLSJAVA-42321CellsHelper.setSignificantDigits() should not be (global) static functionEnhancement 
CELLSJAVA-42327Some shapes are distorted and changed in Excel to PDF renderingBug 
CELLSJAVA-42290Mdashes and ndashes inserted into TextBoxes in charts are not rendered properly in chart’s PDFBug 
CELLSJAVA-42338Wrong results when using SUMIFS formulasBug 
CELLSJAVA-42337Aspose.Cells is unable to calculate the value of cell B4 of Calculations worksheetBug 
CELLSJAVA-42330Weird result when converting from Excel to PDF or PDF/A using threadsBug 
CELLSJAVA-42331Changes to comment author field are not preserved Bug 
CELLSJAVA-42328Wrong IconSet returned Bug 
CELLSJAVA-42324Chart’s background is missing after setting a picture’s dataBug 
CELLSJAVA-42340Exception in thread “Thread-2” java.lang.OutOfMemoryError: GC overhead limit exceededException 
CELLSJAVA-42334Exception “Error for ZipFile” is thrown when using OutputFileStreamException 
CELLSJAVA-42326com.aspose.cells.CellsException: Invalid password on opening the Excel fileException 

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 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 GridWorksheet.CustomColumnCaption property

Gets or sets the custom column caption for the worksheet - Aspose.Cells.GridDesktop.

Adds GridWorksheet.CustomRowCaption property

Gets or sets the custom row caption for the worksheet - Aspose.Cells.GridDesktop.

Adds GridDesktop.GetVersion() method

Get the release version.

Adds GridWebInstance.resize() function in GridWeb client js,(GridWebInstance is the GridWeb control object)

Makes the GridWeb control to be compatible with current browser window size.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs: