Aspose.Cells for Python via Java 21.6 Release Notes

CELLSJAVA-43466CellsException: Error for ZipFile while importing odsEnhancement
CELLSJAVA-43463Timeline is broken after saving fileBug
CELLSJAVA-43464PivotField.hideItem() does not take effect in the output fileBug
CELLSJAVA-43470Text after a “br” tag within a “th” tag gets truncated when importing an HTML documentBug
CELLSJAVA-43481Getting the wrong formula from a cellBug
CELLSJAVA-43490Document properties cannot be extractedBug
CELLSJAVA-43491The value of the formula using the data table cannot be extracted correctlyBug
CELLSJAVA-43498Formatted result of numeric value is incorrect for zh_CN localeBug
CELLSJAVA-43451Content of the Excel file is displayed incorrectly and ChangeStyle (spring) demo is not working properlyBug
CELLSJAVA-43484Content layout is inconsistent in Excel to PDF renderingBug
CELLSJAVA-43465Missing few series of graph while converting Excel to PDFBug
CELLSJAVA-43468Issue with equation of straight line in Excel to PDF renderingBug
CELLSJAVA-43432Chart content mismatched when re-saving an XLS file formatBug
CELLSJAVA-43475Regression: Line wrapped cells are cut offBug
CELLSJAVA-43478Regression: NUMBERS to PDF, missing lot of dataBug
CELLSJAVA-43485Regression: Extra content when rendering PDF from ODSBug
CELLSJAVA-43492Converting an XML (SpreadsheetML) file removes Hidden setting in “Name Definition” in the output XLS and XLSXBug
CELLSJAVA-43486NullPointerException when converting an HTML document to a WorkbookException

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 Python via Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Changes the behavior of Cell.IsErrorValue property.

In old versions, this property only applies to formula cells. To make it consistent with other properties, from 21.6 we check non-formula cells too and if its value is error value, we also return true. User may check Cell.IsFormula property first if he only needs to check error value for formula cells.

Changes the behavior of Cell.Value property.

In old versions, this property always returns DateTime object if the cell is formatted as date time and its value is numeric. From 21.6, this property returns the numeric value itself if it exceeds the maximum valid DateTime value. With this change the returned object is consistent with what shown in the formula bar of ms excel.

Adds Cell.IsNumericValue property.

Provides convenient and efficient way for user to check whether one cell’s value is numeric value(int, double, datetime).

Adds overloaded methods of Cell.SetSharedFormula()/SetArrayFormula()/SetDynamicArrayFormula().

Support to set array formulas and shared formulas with predefined values.

Adds enum PdfFontEncoding.

Represents pdf embedded font encoding.

Adds PdfSaveOptions.FontEncoding property.

Gets or sets embedded font encoding in pdf.

Adds SlicerCacheItem.Value property.

Returns the label text for the slicer item. Read-only.

Adds GlobalizationSettings.GetProtectionNameOfPivotTable() method.

Gets the protection name in the PivotTable.

Adds FileFormatUtil.FileFormatToSaveFormat method.

Converts file format to save format.