Excelize v2.6.1

• Will be released: August 22, 2022

Release Notes

The most notable changes in this release are:

Compatibility

• Rename exported constant TotalColumns to MaxColumns
• Rename exported variable ErrMaxFileNameLength to ErrMaxFilePathLength
• Rename exported variable ErrWorkbookExt to ErrWorkbookFileFormat
• Remove exported variable ErrEncrypt
• Change worksheet name case-insensitive

Notable Features

• New support 34 formula functions: CONVERT, COVARIANCE.S, DAVERAGE, DAYS360, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP, EDATE, EOMONTH, EUROCONVERT, GROWTH, HYPERLINK, MINVERSE, MMULT, NETWORKDAYS, NETWORKDAYS.INTL, PEARSON, RSQ, SKEW.P, SLOPE, STDEVPA, STEYX, TREND, WEEKNUM, WORKDAY, WORKDAY.INTL
• The AddShape function now support assigning a macro to the shape
• Add support for the 1900 and 1904 date system, related issue #1212
• Add support update cell hyperlink, related issue #1217
• The AddPicture function now allowing insert EMF and WMF format images, related issue #1225
• Make workbook open failed exception message clear, new exported variable ErrWorkbookPassword for the error message on receiving the incorrect workbook password
• New exported constants MinFontSize and MinColumns
• Add array formula support for the formula calculation engine
• Support for workbook encryption by password, related issue #199
• RichTextRun support set superscript and subscript by vertAlign attribute
• The DeleteDataValidation function support deleting all data validations in the worksheet, related issue #1254
• Formula calculation engine support percentile symbol in condition criteria expression
• Formula calculation engine support dependence formulas calculation, related issue #1262
• Add export option MaxCalcIterations for specifies the maximum iterations for iterative calculation
• Add export type ColorMappingType for color transformation types enumeration
• Support adjust table range when removing and inserting column/row
• Support set and get color index, theme and tint for sheet tab, related issue #1283

Improve the Compatibility

• Improve the compatibility with invalid internal styles count, resolve issue #1211

Bug Fixes

• Fix generated file corrupted when the same field is used for pivot table data and rows/columns, resolve issue #1203
• Fix get incorrect rich text value caused by missing cell type checking, resolve issue #1213
• Fix incorrect cell data types casting results when number formatting, resolve issue #1219
• Fix set cell value with column and row style inherit issue, resolve issue #1163
• Fix panic when adding pane on empty sheet views worksheet
• Fix the problem of multi arguments formula calculation in some case
• Fix generated file corrupted caused by incorrect worksheet header footer fields order, resolve issue #1257
• Fix set cell value failed in some case, resolve issue #1264
• Fix the panic when set or get sheet view options on the sheet without views options
• Fix generated workbook corruption caused by empty created or modified dcterms in the document core properties
• Fix doc properties missing after creating new worksheet, resolve issue #1298

Performance

• Improve performance for set sheet row and the merging cells, fix performance impact when resolving issue #1129
• Optimization formula calculation performance

Miscellaneous

• The dependencies module has been updated
• Unit tests and godoc updated
• Documentation website with multilingual: Arabic, German, Spanish, English, French, Russian, Chinese, Japanese, and Korean, which has been updated