Breaking Changes from the Previous Release

• While using DsExcel v4.0 or earlier, user could set big decimal in the cell. But from version 4.1 onwards, big decimal was handled as custom object due to which it does not behave as big decimal if user of v4.0 or earlier is setting it in a cell.

  In order to be compatible with earlier behavior, DsExcel has introduced IDataOptions.getBigDecimalAsDouble and IDataOptions.setBigDecimalAsDouble methods to get or set whether to treat big decimal as double. If you are using BigDecimal or BigInteger as a custom object in version 4.1.0~5.0.2, you need to call setBigDecimalAsDouble(false) in your code.

Enhancements from the Previous Release

• Improved behavior of IRange.AutoFilter method to create a filter without condition.
• Added SerializationOptions.setIgnoreSheets method to export a workbook without worksheet data.
• Added IWorksheet.ToJson(Stream stream) method to export individual worksheets to a JSON stream.

Resolved Issues

• Resolved an issue where formulas were not retained in an exported Excel file.
• Resolved an issue where ToJson method generated invalid JSON file when Excel file included multi-line comments.
• Resolved an issue where incorrect cell value were present when evaluating formula using DsExcel.
• Resolved an issue where cell style was incorrect in exported Excel file after loading the JSON exported by SpreadJS.
• Resolved an issue in which an exception was thrown on calling workbook.toJson method.
• Resolved an issue of performance degradation when evaluating values from a particular Excel file.
• Resolved an issue where formula result of SUBSTITUTE was incorrect.