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()
andSetConditionalFormat()
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()
andHSLToRGB()
has been added for support convert RGBA, HSL color - New function
NewDataValidation()
and series functionsDataValidation.SetDropList()
,DataValidation.SetError()
,DataValidation.SetInput()
,DataValidation.SetRange()
,DataValidation.SetSqref()
andDataValidation.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