« Changelog History


excelize v2.2.0 Release Notes

Release Date: 2020-05-10 // almost 4 years ago

  • 🚀 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 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 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 ignore 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