Released: Mar 11, 2024

Updates in V24.3

Features

• Added support for EVALUATE function.
• Improved filtering in GridDesktop.
• Support for rich text when using formula editor box.
• Convert Microsoft Excel spreadsheets to ODS using ODF 1.3 standard.
• Support for processing navigation links when converting AZW3 to XLSX.

Fixes

• The ratios of width and height do not change simultaneously when Picture.IsLockAspectRatio is set to true.
• Data shift failed after calling InsertRange method.
• ISERROR function returns false for NPER #NUM! error.
• Calling recalculation on the workbook produces #VALUE! error.
• Formulas not calculated correctly.
• Chart data errors after calling Chart.Calculate().
• The vertical text spacing in PDF B does not match the spacing in Excel.
• Page layout error when converting files to images.
• Importing XML with line breaks into a table does not format correctly.
• The bold and italic style has been passed to the next paragraph of text when saving file to PDF.
• The position of the line break in the Request section is different with Excel.
• Paging error occurred when saving to PDF.
• Fail to import HTML file with SVG image.
• Line break is incorrect in the output XLSX after setting HTML string in cell.
• Issue with MergeEmptyTdForcely Option in HtmlSaveOptions.
• HTML line break is not being respected.
• Exporting XLSX file to HTML is corrupted and has a gibberish prefix.
• The underline contained in the text is lost when converting the file to HTML.
• While pivoting the Excel sheet, some of the rows in the date column are showing as number.
• External DDE link data source is not replaced after setting new value.
• Cell references change failed after copying Worksheet.
• Randomly corrupting Excel files on save.
• Invalid shared formulas returns when loading Excel 5 file.
• M4a file is detected as CSV when passing it as stream.
• Unable to replace date formatted text.
• Some Coditional formatting lost when converting to ODS.
• Picture in cell is missing after resaving the sample file.
• The result file crashes when resaving XLSM and using SaveFormat.Auto.
• Insert/Delete operations cause exception when the updated range intersects with existing dynamic array formula.
• CalculateFormula throws NullReferenceException after copying into a cell range.
• Loading XSLX file raises NullReferenceException exception.
• Invalid end column index exception on CreateRange function.
• Exception Index was outside the bounds of the array when loading XLS files via stream.