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
andGetSheetFormatPr
, support to set and get worksheet formatting properties, relate issue #635 - New API:
GetCols
andCols
, support columns iterator AddChart
support specified logarithmic scale on Y-axis, relate issue #661AddPicture
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 withoutr
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