Released: Sep 10, 2020

Updates in V20.9

Features

• Added support for getting and setting slicer shape properties.
• GridWeb client API now supports adding and removing comments.
• Added new properties to the public API.
• Improved support for freezing and splitting worksheets.

Fixes

• Fixed an issue where chart does not allow treating #N/A as empty cells when saving as PDF.
• Fixed an issue where Kaiti font is not properly rendered.
• Fixed an issue where query tables are not loaded from ODS file.
• Fixed an issue where macros should be removed when combining/copying workbooks.
• Fixed an issue with Smart Markers having conditional formatting applied.
• Fixed an issue where Currency with custom format is shown outside of cell in HTML.
• Fixed an issue with saving empty sheets with exported grid line settings to HTML.
• Fixed an issue where Pivot Table isn’t properly shown after XLSX to PDF conversion.
• Fixed an issue where CalculateFormula() calculates differently than Microsoft Excel.
• Fixed an issue where formulas containing names that don’t exist show up as WorkbookName!Name.
• Fixed an issue where custom negative numbers are rendered incorrectly to PDF.
• Fixed an issue with importing text file with double quotes.
• Fixed an issue where custom negative numbers (using Switzerland region) are rendered incorrectly to PDF.
• Fixed an issue where needing to sync scrolling of two grids just like excel’s SyncScrollingSideBySide.
• Fixed an issue with being unable to select cells using keyboard arrow keys when sheet set as read only.
• Fixed an issue where transparent marker points in chart in the Excel file are getting distorted in the output PDF.
• Fixed an issue when foreground footer image becomes background.
• Fixed an issue where XLSX to TIFF conversion results in a black box.
• Fixed an issue where converting worksheet to TIFF to Image is blacked out.
• Fixed an issue with shape distortion after converting to PDF files.
• Fixed an issue where X-axis is not correct while converting Excel chart to PDF.
• Fixed an issue where deleting blank rows/columns corrupts Excel documents.
• Fixed an issue with wrong PowerQueryFormula.FormulaDefinition.
• Fixed an issue with being unable to produce desired formatting using shift.
• Fixed an issue where converting XLS to HTML produces empty file.
• Fixed an issue where MaxColumn is set to Column XFD after calling InsertCutCells().
• Fixed an issue where workbook with Waterfall chart cannot be opened using Excel 2016 after copying.
• Fixed an issue where an exception is raised while adding slicer for table.
• Fixed an issue with an exception when saving an XLS file to XLSX.
• Fixed an issue with exception “File is corrupted” when loading an XLS file format.
• Fixed an issue with ArgumentOutOfRangeException when converting Excel files.
• Fixed an issue with an exception when converting particular XLSX files to XLS.
• Fixed an issue where some properties are missing when combining workbooks.