Released: Mar 7, 2023

Updates in V23.3

Features

• Added support for setting, reading and saving 'ENCODEURL' and 'LET' functions.
• Adds 'CalculationOptions.LinkedDataSources' property which allows the user to set linked data sources in calculation formulas.

Fixes

• Text shadow effect disappears when saving file to PDF.
• The text font color of smart art should be black.
• SUBTOTAL and other aggregate functions do not work correctly inside a dynamic array formula.
• Incorrect value returns when calculating SWITCH statement Array Formula.
• Issue with calculating array formulas with external links having INDIRECT functions.
• Formula error while converting XLSX to XLS.
• Missing axis tick labels when converting chart to image in .NET Core project.
• Exporting image from chart is not the same showing on Excel.
• Github demo: datasource bind example does not work.
• Setting editable range does not take affect in GridWeb.
• Github demo: GridWeb's SessionModes not work.
• Incorrect margins for XLSX to PDF conversions.
• Text box is not visible when converting XLSX to PDF.
• Merged area missing border when saving file to PDF.
• Zorder was not respected when saving PDF if object covers more than one page.
• XLS to PDF: Chart EMF image not rendered.
• HTML to XLSX: Some styles are not shown properly.
• Excel to HTML conversion - some data columns are shifted and formatting is broken.
• Copying range from source to target workbook does not copy data/objects properly.
• PNG images inside cells are not converted into output PDF.
• Content lost after re-saving the Excel file.
• Utilizing Resize method results in corrupted output file.
• The width of copied comments is wrong.
• File corruption after specifying image type when saving Excel to image.
• The comment margin settings changes from Automatic to Fixed.
• The start position, font and character spacing of the text box character string are changed.
• Copied table is corrupted when copying range from other sheet.
• XLS file is corrupted if the chart title is a constant formula.
• Expand tables and move other tables beneath it.
• XLSB to HTML: Table style is not retained upon conversion.
• An Exception should be thrown when shifting the part of the table.
• The result file crashes when inserting Range above Table.
• Unit type of Y Axis should be visible when converting chart to PDF.
• Chart title is missing for treemap chart.
• Shape to image Error when saving file to PDF after copying Workbook.
• Null reference exception when copying a range.
• Exception is thrown when rendering ODS file preview with optional OnePagePerSheet.
• Exception for saving and getting preview.