Released: Dec 17, 2020

Updates in V20.12

Features

• IFS formulas can now be wrapped with curly braces after saving.
• Added support for formulas with Sheet() function.
• Reduced output size when converting to HTML.
• Added the ability to display additional columns when text is overlapping next cells.
• Added the ability to remove ODS macros in Workbook.RemoveMacro.
• Added support for h1 tag when setting Cell.HtmlString.

Fixes

• New worksheet is missing mc:Ignorable="x14ac xr xr2 xr3”.
• Conversion complex XLSM to HTML takes a lot of time.
• Invalid markup with unopened closing SPAN tag is produced while converting Cells document to HTML.
• DirectoryNotFoundException while trying to open HTML.
• Some extra columns in the new output in Excel to HTML rendering.
• Some TDs will cause font error for Wingdings font in HTML to PDF rendering.
• Conversion of HTML to XLSX does not respect styling of the HTML table.
• Images are aligned incorrectly when importing file to HTML.
• Images are over lapping the text when importing HTML to Excel.
• Unencoded quotes in values of HTML attributes.
• Differences while converting Excel to HTML.
• Series’s value is not correct after refreshing pivot data.
• Incorrect PPMT formula execution result.
• Inserting column and changing formula deletes other formulas.
• autofilter does not work as Excel.
• Number converted to scientific during conversion from XLSX to CSV.
• Text is clipped (first line is not displayed) with custom font when auto-fitting rows.
• Border around icon when converting Excel to PDF.
• SetFontFolders not working correctly with data series labels.
• Legend shows the name of the series instead of the label text.
• Issue with copying sheets when “hidden name definition” exists in Excel file.
• Different behavior between version 20.3 and 20.11.
• Ole Object label not retrieved in Excel sheet.
• File is corrupted after clearing chart title.
• Deleting empty columns removes the comments in the columns after the deleted column.
• RefreshPivotData throws exception.
• Exception raised while importing sample files.
• Exception when opening ODS file.
• Exception is thrown When trying to load attached document.
• Cannot load XLTX file.
• Exception when opening XLSB.
• The column index should not be inside the pivottable report exception when calling DeleteBlankColumns.
• Cannot open XLSX.
• Cannot convert XLSX to XLSM.
• ArgumentOutOfRangeException when converting worksheet to image.