Released: Jun 23, 2021

Atualizações na V21.6

Recursos

• Changed behavior of Cell.IsErrorValue property - In old versions, this property only applied to formula cells. To make it consistent with other properties, from 21.6 it now checks non-formula cells too and if its value is an error value, it also returns true. The User may check Cell.IsFormula property first if they only need to check the error value for formula cells.
• Changed behavior of Cell.Value property - In old versions, this property always returned the DateTime object if the cell was formatted as date time and its value was 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 is shown in the formula bar of Microsoft Excel.
• Added Cell.IsNumericValue property - Provides convenient and efficient way for user to check whether one cell’s value is a numeric value (int, double, datetime).
• Added overloaded methods of Cell.SetSharedFormula()/SetArrayFormula()/SetDynamicArrayFormula() - Support to set array formulas and shared formulas with predefined values.
• Added enum PdfFontEncoding - Represents PDF embedded font encoding.
• Added PdfSaveOptions.FontEncoding property - Gets or sets embedded font encoding in PDFs.
• Added SlicerCacheItem.Value property - Returns label text for the slicer item. Read-only.
• Added GlobalizationSettings.GetProtectionNameOfPivotTable() method - Gets the protection name in the PivotTable.
• Added FileFormatUtil.FileFormatToSaveFormat method - Converts file format to save format.

Correções

• CellsException: Error for ZipFile while importing ODS.
• Timeline is broken after saving file.
• PivotField.hideItem() does not take effect in the output file.
• Text after a “br” tag within a “th” tag gets truncated when importing an HTML document.
• Getting the wrong formula from a cell.
• Document properties cannot be extracted.
• The value of the formula using the data table cannot be extracted correctly.
• Formatted result of numeric value is incorrect for zh_CN locale.
• Content of the Excel file is displayed incorrectly and ChangeStyle (spring) demo is not working properly.
• Content layout is inconsistent in Excel to PDF rendering.
• Missing few series of graph while converting Excel to PDF.
• Issue with equation of straight line in Excel to PDF rendering.
• Chart content mismatched when re-saving an XLS file format.
• Regression: Line wrapped cells are cut off.
• Regression: NUMBERS to PDF, missing lot of data.
• Regression: Extra content when rendering PDF from ODS.
• Converting an XML (SpreadsheetML) file removes Hidden setting in “Name Definition” in the output XLS and XLSX.
• NullPointerException when converting an HTML document to a Workbook.