v1.4.0

We are pleased to announce the release of 1.4.0.

Release Notes

The most notable changes in this release are:

Breaking Change

• Add error return value for functions: AddChart(), AddComment(), AddPicture(), AddShape(), AddTable() and SetConditionalFormat()

Notable Features

• New function GetComments() has been added for support retrieves all comments and returns a map of worksheet name to the worksheet comments
• New functions RGBToHSL() and HSLToRGB() has been added for support convert RGBA, HSL color
• New function NewDataValidation() and series functions DataValidation.SetDropList(), DataValidation.SetError(), DataValidation.SetInput(), DataValidation.SetRange(), DataValidation.SetSqref() and DataValidation.SetSqrefDropList() has been added for suppport data validation
• New function AddPictureFromBytes() has been added, relate issue #259
• Function GetCellFormula() now supports shared formula types, relate issue #227
• Support to parse dates further in future
• Use min/mid/max value for 2 and 3 color scale conditional formatting

Bug Fixes

• Improved commenting formatting, fix expands all comment boxes stacked all in one place
• Fix create worksheet by NewSheet() cause file issue, related issue #249

Performance

• Performance optimization 20% faster, 14% memory savings on set cell values. See Performance Figures
• Use github.com/mohae/deepcopy to deep copy worksheets instead of the internal deepcopy function that was using encoding/gob serialization and deserialization