Released: Sep 3, 2021

Updates in 4.2.1

Features

• Added dynamic array and workbook URI links to formula parser.
• Enhanced Range.AutoFit(bool considerMergedCell).

Fixes

• ITickLabels.NumberFormat is not applied when saving a workbook to PDF/Image/HTML file.
• When IAxis.MajorUnit is set, tick labels are duplicated in exported PDF/Image/HTML file.
• When the chart series is added, orders of series and legends are incorrect in exported XLSX file.
• Values of category axis are incorrect in exported PDF/Image/HTML file.
• Exception is thrown on saving PDF/Image/HTML file, if ISeries.Formula is set.
• The exported file is incorrect after deleting columns by GcExcel.
• Exception is thrown on using Formula parser if syntax contains '.'.
• Exception is thrown on opening an Excel file.
• Cell's number format is different from the original JSON file in exported JSON.
• The exported CSV file is incorrect when Range.Value contains '\n'.
• Exception is thrown on opening an Excel file(exported by an unknown program).
• The font style is not correct in exported PDF file.
• Exception should be thrown when setting Worksheet.Name which contains invalid characters.
• The text in the textbox is not exported to PDF correctly.
• The result of row height is incorrect in Range.RowHeight using GcExcel.
• The exported JSON file by GcExcel is too large.
• Exception is thrown on adding table.
• Fallback font is not used after FontFolderPath is set when exporting to PDF file on Linux.
• The result in exported Excel file is not correct after delete columns/rows.