Excelize v1.4.0

• Released this on: August 14, 2018
• GitHub Release: https://github.com/xuri/excelize/releases/tag/v1.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 support data validation
• New function AddPictureFromBytes has been added, related issue #259
• Function GetCellFormula now supports shared formula types, related 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