« Changelog History


excelize v2.3.1 Release Notes

Release Date: 2020-09-22 // about 3 years 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