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: HeaderFooterImagePositionTypeand 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 SetPageLayoutfunction 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

• 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