Released: Jun 18, 2021

Updates in V21.6

Features

• Converting Microsoft Excel sheets to text files now removes single quotes from the beginning.

Fixes

• Sorting is not working when data contains non alpha numeric characters.
• Japanese calendar using an Excel function is not read correctly.
• CellsException: Error for ZipFile while importing ODS.
• Text placement shifted to the left when saving as HTML.
• Escape and line break chars not correctly rendered when converting HTML to Excel.
• Conditional Format with Data Bars Show Values in HTML Export.
• Accounting format combined with 6 point Font distorts numbers in HTML.
• Text with Vertical Text Alignment Disappears in HTML.
• Excel formulas are skipped/changed after saving file.
• Custom number format not displayed correctly in PDF.
• Chart labels repeated while converting the attached Excel files to PDF.
• Unexpected Data labels appeared in the output image of Chart.
• Font substitution warnings not working in chart to image conversion.
• XLS to PDF conversion problem.
• Header-Footer not available on the first page when exported to Excel.
• Referenced image is not rendered in PDF.
• SmartMarker dynamic formula has wrong expanding cell style.
• Smart Markers dynamic formula inserts cells according to left expanded column but not according to the columns in formula.
• Pivot table refresh issue.
• Regression: getLastSavedUniversalTime returns incorrect date.
• Cells Track Changes Exception.
• Regression: Invalid reference for list.
• Infinite loop when saving copied workbook.
• Issue with data sorting when clicking on header links in the GridWeb spring demo.
• Issue with edit mode in the GridWeb Java.
• Fonts are not embedded in PDF for non ASCII characters while setting EmbedStandardWindowsFonts to false.
• Unable to change font family of chart elements from “Calibri” to “Aktiv Grotesk”.
• X-Axis labels are cut off.
• Regression: missing row data for .numbers files.
• 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.
• Exception raised while opening XLSX from large file.
• java.lang.NullPointerException raised while calling Cells.deleteColumn() with the latest version 21.3 whereas it works with 21.2.
• IndexOutOfBoundsException on clicking other sheet pages in evaluation mode.
• NullPointerException in getFormulaLocal() with custom GlobalizationSettings.
• Exception “java.lang.NullPointerException” occurred when using custom style file in GridWeb.
• NegativeArraySizeException occurs on Workbook load.
• NullPointerException on Workbook.save method.
• NullPointerException when converting an HTML document to a Workbook.