Aspose.Cells for Java 20.9 Release Notes

CELLSJAVA-40792Pivot table is not created for ODS fileNew Feature
CELLSJAVA-43263SmartMarker problem when a cell is set fill color and conditional formattingBug
CELLSJAVA-43269Not able to get value from pivot sheetBug
CELLSJAVA-43272Image shrinks after setting width scalableBug
CELLSJAVA-43280Filter issue after the pivot table refreshBug
CELLSJAVA-43281Refresh pivot table issueBug
CELLSJAVA-43285Static filters are lost after refreshing the pivot tableBug
CELLSJAVA-43288The result XLSB file is corrupt when saving file to XLSBBug
CELLSJAVA-43289Filter issue after refresh of pivot tableBug
CELLSJAVA-43293Issue with filter options after PivotTable.refreshData()Bug
CELLSJAVA-43279Values are not fetched properly using getStringValue()Bug
CELLSJAVA-43291Grid content not visibleBug
CELLSJAVA-43037Font problem on PDF conversionBug
CELLSJAVA-43249Printing issues while using physical printers, XPS and PDF printerBug
CELLSJAVA-43254Font difference while converting spreadsheet to imageBug
CELLSJAVA-43266Java version does not support loading font from current user fonts folder by defaultBug
CELLSJAVA-43268Excel to TIFF rendering - some of the values are replaced with " #” charsBug
CELLSJAVA-43275Aspose.Cell for Java 20.8 com.aspose.cells.CellsException: Error for ZipFileBug
CELLSJAVA-43277Problem with height width ratioBug
CELLSJAVA-43245Combo chart is not displayed correctly after converting Excel file to PDFBug
CELLSJAVA-43276Line break issues while converting XLSX to PDFBug
CELLSJAVA-43261SmartMarker: when using group:merge with Number Format Percentage, the expanding result is wrongBug
CELLSJAVA-43265Cannot load XLSX fileBug
CELLSJAVA-43270Content duplication (embedded Word) when copying worksheetBug
CELLSJAVA-43271WaterFall Chart Not preserving SetAsTotal PropertyBug
CELLSJAVA-43287Adding autofilter corrupts the workbookBug
CELLSJAVA-43290Processing does not return when saving XML Spreadsheet 2003 file in MS Excel workbook formatBug
CELLSJAVA-43267Exception “java.lang.NullPointerException” when calculating pivot table in the sheetException

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 AbstractCalculationEngine.ProcessBuiltInFunctions property

For performance and user’s convenience consideration, we add this property and make its default value as false so user can concentrate on those functions that have not been supported by built-in engine. If user’s existing implementation of AbstractCalculationEngine changed some built-in functions’ calculation, user should override this property to make it as true from 20.9.

Adds TxtLoadOptions.HasTextQualifier property

Denotes whether there is text qualifier for cell values in the template file.

Adds TxtLoadOptions.TextQualifier property

Specifies the text qualifier for cell values in the template file.

Adds HtmlSaveOptions.ImageScalable property

Indicates whether to use scalable unit to describe the image width. The default value of the property is true.

Adds Slicer.AlternativeText property

Gets or sets the descriptive (alternative) text string of the Slicer object.

Adds Slicer.ColumnWidthPixel property

Gets or sets the width in unit of pixels for each column of the slicer.

Adds Slicer.HeightPixel property

Gets or sets the height of the specified slicer, in pixels.

Adds Slicer.IsLocked property

Indicates whether the slicer shape is locked.

Adds Slicer.IsPrintable property

Indicates whether the slicer object is printable.

Adds Slicer.LeftPixel property

Gets or sets the horizontal offset of slicer shape from its left column, in pixels.

Adds Slicer.LockedAspectRatio property

Indicates whether locking aspect ratio.

Adds Slicer.Placement property

Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.

Adds Slicer.RowHeightPixel property

Returns or sets the height, in pixels, of each row in the specified slicer.

Adds Slicer.Title property

Specifies the title of the current Slicer object.

Adds Slicer.TopPixel property

Gets or sets the vertical offset of slicer shape from its top row, in pixels.

Adds Slicer.WidthPixel property

Gets or sets the width of the specified slicer, in pixels.

Adds Worksheet.PaneState property and PaneStateType enum.

Represents the state of pane in the worksheet.

Adds OdsLoadOptions.RefreshPivotTables property.

Indicates whether refreshing pivot table when loading .ods files.

Adds FilterColumn.IsDropdownVisible property.

Indicates whether the AutoFilter button for this column is visible.

Obsoletes Filter.Visibledropdown property.

Use FilterColumn.IsDropdownVisible instead.

Adds CopyOptions.KeepMacros property.

Indicates whether keeping the macros in the target workbook. It only effects when original workbook does not contains macros.

Adds overload Workbook.Copy(Workbook,CopyOptions) method.

Copies workbook with options.

Adds WarningType.InvalidAutoFilterRange enum.

Represents the warning type that the range could not auto filtered.

Adds Chart.DisplayNaAsBlank property.

Indicates whether displaying #N/A as blank value.

Adds CrossType.Minimum enum.

Represents the axises cross at the minimum value.

Adds XlsbSaveOptions.ExportAllColumnIndexes property.

Indicates whether export column indexes for all cells when saving XLSB files.