excelize v2.3.1 Release Notes

Release Date: 2020-09-22 // 7 months ago
  • ๐Ÿš€ We are pleased to announce the release of version 2.3.1. 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 open spreadsheet with password protection by ECMA-376 document standard encryption, relate issue #199
    • โž• Add checking and limits for the worksheet
    • ๐Ÿ’… Extend pivot table functionality: support set the header, style, and table options for the pivot table
    • ๐Ÿ”’ Security vulnerabilities and patches

    ๐Ÿ‘Œ Improve the Compatibility

    • ๐Ÿ Compatible with Go 1.15, fix unit test failed on Windows and potential race condition, relate issue #689
    • 0๏ธโƒฃ Default row height compatibility with Apache OpenOffice and Kingsoft WPSโ„ข
    • ๐Ÿ‘Œ Improve compatibility for phonetic hint and sheet tab color

    ๐Ÿ› Bug Fixes

    • ๐Ÿ›  Fix RemoveRow slice bounds out of range cause panic in some case, resolve #686
    • ๐Ÿ›  Fix stream writer generated corrupted files issue
    • ๐Ÿ›  Fix the scale for add picture not work, resolve #691

    Miscellaneous

    • โšก๏ธ Unit tests update and typo fixed
    • ๐Ÿ“š Documentation website with multilingual: English, French, Russian, Chinese, Japanese, and Korean, which has been updated
    • Welcome join the Slack channel to meet other members of our community

Previous changes from v2.3.0

  • ๐Ÿš€ 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

    Miscellaneous

    • ๐Ÿ‘Œ 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