We are pleased to announce the release of version 2.2.0. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.

Release Notes

The most notable changes in this release are:

Notable Features

• Using the worksheet index instead of ID in the following functions: GetSheetName, GetSheetIndex, GetActiveSheetIndex and SetActiveSheet, relate issue #485
• New function GetSheetList to get the worksheet, chart sheet, and dialog sheet name list of the workbook
• New function AddChartSheet support create chart sheet, relate issue #451
• New function UnsetConditionalFormat, support for remove conditional format, relate issue #571
• New function DeleteDataValidation, support delete data validation, relate issue #348
• New function SetCellRichText, support set rich text, relate issue #172
• New functions InsertPageBreak and RemovePageBreak, support for insert and remove page break, relate issue #492
• The AddPivotTable API changed, support for setting date field subtotal and names of the pivot table, relate issue #582
• The AddPivotTable support to set the filter for the pivot table, relate issue #598
• The AddPivotTable allow empty filter, data, and rows in the pivot table
• Export ExcelDateToTime function to convert excel date to time
• Export Style structs to allow create the style for cells by given JSON or structure pointer, relate issue #470

Bug Fixes

• Fix greaterThanOrEqual and lessThanOrEqual operators did not work when setting the conditional format for cell by SetConditionalFormat, resolve issue #608
• Fix corrupt worksheet created by StreamWriter, resolve issue #576
• Escape character in the formula, resolve issue #578
• Fix the DuplicateRowTo function doesn't duplicate merged cells, resolve issue #586
• Fix conditional formatting hides the adjacent borders by ignoring empty conditional format style, resolve issue #200
• Fix missing comments by GetComments, resolve issue #345
• Fix reading wrong string by GetCellValue in some case, resolve issue #602
• Check and fill the cell without r attribute in a row element, fix returned empty value when GetCellValue in some case
• Allow empty or default cell style formats, resolve #628

Performance

• Reduce redundant memory copy in getRowHeight

Miscellaneous

• Remove calculated properties to make recalculate formulas in some spreadsheet applications, such as Kingsoft WPS™ Office
• Add missing checking error in unit tests
• Documentation website with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated