Released: Oct 14, 2021

Updates in V21.10

Features

• Added the ability to open files with HTML tables as XLS files.
• Added support for the Range.CurrentRegion property.
• Updated hyperlink(Sheet1!A1) when changing the name of the worksheet.
• Improved support for autofill range with fill type.
• Added the ability to remove invisible shapes when rendering HTML.

Fixes

• Conditional formatting of ODS is lost in Microsoft Excel if type is “Contains Text”.
• Issue with retrieving Ranges (RefersTo) with an offset function.
• Application halts while calculating large files and UDFs.
• Blurry radio-buttons when converting XLSM to HTML.
• Incorrect calculation of operators in formula when operands are ranges.
• Distorted chart created in converted Html.
• Missing text, wrong text alignment and missing percentages in chart.
• Issue with get and set Tab color in GridDesktop.
• Aspose.Cells.GridWeb SessionMode does not work.
• Issue with Xml import.
• XLSX to HTML conversion does not retain sequence of invisible characters.
• Image shifts in specific XLS files when rendered to HTML.
• Image is not visible when converting specific XLSX file to HTML.
• Issue with font text in footer field for Excel rendering.
• Unable to successfully import the XML file into the template file.
• Unnecessary whitespace rendered during Excel to EMF conversion.
• The “strCache” node missing in a XML.
• No longer able to copy correct Value axis tick label’s font names.
• Cannot show percentage values in datalabel.
• Some Data Labels in the chart are missing.
• Chart line is different with Chart.ToImage function than in Excel.
• A resource that is out of the selected range should not be exported to HTML.
• Distortion of document page color and layout.
• DataMashup information not retrieved from Excel file.
• Watermark in Excel file cannot be correctly generated and displayed.
• Shadow effect is applied to image(s) when converting from XLSM to XLS.
• Icon conditional formatting is lost when saving as html.
• Error when copying worksheets.
• Text is clipped in printer output after call to AutoFitRows.
• Issue with Cell data validation input fields in XLSB format.
• Wrong row with large height is added into HTML table.
• Problems with HtmlString Font when Excel saved as HTML once.
• Issue while refreshing Pivot table after adding data.
• Exception when loading the Excel file.
• CalculateData method on pivot table throws exception.
• “Input string was not in a correct format.” exception when open XLSX file.
• Null exception when open NUMBERS file.