Excelize Files

We are pleased to announce the release of version 2.9.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:

Breaking Change

• Upgrade requirements Go language version is 1.23 or later, for upgrade of dependency package golang.org/x/crypto
• Change the data type of DataValidationType, DataValidationErrorStyle, DataValidationOperator, PictureInsertType from int to byte
• SetCellInt function required int64 data type parameter, resolve issue [#2068]
• When adding drawing objects such as pictures, charts, shapes, and form controls, the offset setting will no longer affect the size of the drawing object, related issue [#2001]

Notable Features

• Add new fields GapWidth and Overlap in the Chart data type
• Add new fields ShowDataTable and ShowDataTableKeys fields in the ChartPlotArea data type
• Add new field Alignment in the ChartAxis data type
• Add new field DataLabel in the ChartSeries data type
• Add new field PageOrder for PageLayoutOptions data type
• Add 2 new exported error variables: ErrPageSetupAdjustTo and ErrStreamSetColStyle
• Add 2 new exported enumerations: HeaderFooterImagePositionType and IgnoredErrorsType
• Add 2 new exported data types: CalcPropsOptions and HeaderFooterImageOptions
• Add 2 new functions: SetCalcProps and GetCalcProps support setting and getting workbook calculation properties
• Add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values, support apply number format for the Japanese calendar years, the Korean Danki calendar and the Republic of China year, related issue [#1885]
• Add new function AddHeaderFooterImage to support set graphics in a header and footer, related issue [#1395]
• Add new function AddIgnoredErrors support to ignored error for a range of cells, related issue [#2046]
• Add new function SetColStyle for streaming writer to support set columns style, related issue [#2075]
• The AddChart and AddChartSheet function support set chart axis text direction and rotation, related issue [#2025]
• The AddChart and AddChartSheet function support set gap width and overlap for column and bar chart, related issue [#2033]
• The AddChart and AddChartSheet function support set the format of the chart series data label, related issue [#2052]
• The AddChart and AddChartSheet function support set data table for chart, related issue [#2117]
• The AddFormControl function support set cell link for check box, related issue [#2113]
• The SetPageLayout function support set page order of page layout
• The DeletePicture function support delete one cell anchor image, related issue [#2059]
• An error will be return if the option value of the SetPageLayout function is invalid
• Support adjust data validations cross multiple worksheets, related issue [#2072]
• Support apply number format with hash and zero place holder, related issue [#2058]
• Support apply number format with ? symbol
• Support to insert one cell anchor drawing object when specified the positioning as "oneCell", related issue [#2002]

Bug Fixes

• Fix a v2.9.0 regression bug, corrupted workbook generated by open the workbook generated by stream writer, resolve issue [#2015]
• Fix redundant none type pattern fill generated, resolve issue [#2014]
• Fix missing vertical and horizontal border styles in some case, resolve issue [#2048]
• Fix conditional format's border styles missing in some case, resolve issue [#2061]
• Fix get pivot tables panic in some case, resolve issues [#1954] and [#2051]
• Fix GetStyle function can not get VertAlign format
• Fix CalcCellValue function subexpressions aren't correctly calculated in some case, resolve issue [#2083]
• Fix delete wrong images in some case which caused by image reference detection issue
• Fix cell default style doesn't override by none-zero row style when set row by stream writer
• Fix redundant cols element generated by stream writer
• Fix panic on set chart title font, resolve issue [#2102]
• Fix panic on delete calc chain in some case
• Fix incorrect formula calculation result caused by shared formula parse error, resolve issue [#2056]
• Fix corrupted workbook generated when an inner ZIP64 file size exceeds 4GB
• Fix sheet name error in defined name after rename sheet, resolve issue [#2126]

Performance

• Use a 3 times faster deepcopy library github.com/tiendc/go-deepcopy instead of github.com/mohae/deepcopy, related issue [#2029]
• Fix performance regression in v2.9.0, reduce trim cell value memory allocation for blank cells
• Improve performance for calculate formula when formula contains whole column and row reference
• Rows iterator speedup about 20%, memory allocation reduce about 10%

Miscellaneous

• The dependencies module has been updated
• Unit tests and godoc updated
• Documentation website with multilingual: Arabic, German, English, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Chinese Simplified and Chinese Traditional, which has been updated.
• excelize-wasm NPM package release update for WebAssembly / JavaScript support
• excelize PyPI package release update for Python

Thank you

Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:

• @wushiling50
• @imirkin (Ilia Mirkin)
• @Juneezee (Eng Zer Jun)
• @Arpelicy
• @zhuhaicity (ZhuHaiCheng)
• @xxf0512 (xxf)
• @gypsy1234
• @mengpromax (MengZhongYuan)
• @hly-717
• @kurtinge (Kurt Inge Smådal)
• @IvanHristov98 (Ivan Hristov)
• @artur-chopikian (Artur Chopikian)
• @romanshevelev (Roman Shevelev)
• @LZCZ
• @hm3248
• @moisespsena (Moises P. Sena)
• @paolobarbolini (Paolo Barbolini)
• @timesince
• @shcabin
• @tgulacsi (Tamás Gulácsi)
• @R3dByt3 (R3dByt3)
• @Now-Shimmer