Released: Feb 11, 2022

Updates in 5.0.3

Funktionen

• Added option to control whether treat a BigDecimal as a double for cell values.
• Added ability to add a filter without conditions using IRange.AutoFilter().
• Added options to control serializing workbooks to JSON without worksheets.

Fehlerkorrekturen

• Formulas are lost in exported Excel file.
• ToJson method generates invalid JSON file when Excel file having multi-line comments.
• Cell value is incorrect when evaluating formula using GcExcel.
• The cell style is incorrect in exported Excel file after loading the JSON exported by SpreadJS.
• Exception is thrown on calling workbook.toJson() method.
• Performance degradation when evaluating values from the particular Excel file.
• The formula result of SUBSTITUTE is incorrect.