excelize v2.3.0 Release Notes

Release Date: 2020-08-09 // over 3 years ago
  • ๐Ÿš€ We are pleased to announce the release of version 2.3.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

    • ๐Ÿ‘Œ Support to set cell values concurrent, relate issue #670
    • ๐Ÿ†• New API: SetSheetFormatPr and GetSheetFormatPr, support to set and get worksheet formatting properties, relate issue #635
    • ๐Ÿ†• New API: GetCols and Cols, support columns iterator
    • ๐Ÿ‘ AddChart support specified logarithmic scale on Y-axis, relate issue #661
    • ๐Ÿ‘ AddPicture support insert image autofit cell
    • โž• Add limits for total columns, row and filename length
    • ๐Ÿ‘ Formula calculation engine support defined name, relate issue #665
    • โšก๏ธ API CalcCellValue update, formula calculation engine working in progress: 12 new functions has been added, COUNTA, ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISNONTEXT, ISODD, ISNUMBER, MEDIAN, NA, SUMIF

    ๐Ÿ‘Œ Improve the Compatibility

    • Compatible to case-sensitive doc parts path
    • Storage string to SST (shared string table), relate issue #622
    • ๐Ÿ‘Œ Support the row element without r attribute in the worksheet
    • ๐Ÿ‘Œ Support XML multi namespace, make compatible with Kingsoft WPSโ„ข Office, relate issue #651
    • ๐Ÿ‘Œ Improve the compatibility of the auto filter with Office 2007 - 2010, resolve #637

    ๐Ÿ› Bug Fixes

    • Avoid duplicate filter database in workbook defined name
    • ๐Ÿ’… Avoid creating duplicate style, resolve #643
    • Escape characters for set rich-text
    • ๐Ÿ›  Fix the issue, comment shapes are changed after reopening spreadsheet created by Excelize, resolve #672
    • ๐Ÿ›  Fix panic when enabling compiler inline flags, resolve #677 and #679
    • ๐Ÿ›  Fix the accuracy issue of getting cell value of percentage cell


    • ๐Ÿ‘Œ Improved error handling and fix crash when open invalid spreadsheet file
    • โž• Add missing checking error in unit tests
    • ๐Ÿ“š Documentation website with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated