We are pleased to announce the release of 1.3.0.

Release Notes

The most notable changes in this release are:

Breaking Change

• Make row index consistent in function SetRowHeight() and GetRowHeight(), fix issue #205

Notable Features

• New function SetSheetRow() has been added for support write the whole line at once, relate issue #96 and #194
• New functions GetColOutlineLevel(), GetRowOutlineLevel(), SetColOutlineLevel() and SetRowOutlineLevel() has been added for suppport creat group
• Add iterator method for Rows, new functions Columns(), Next() and Error() has been added
• Function SetCellValue() now supports bool and time.Duration type value
• Function AddTable() now supports set name of table, relate issue #216
• Function AddPicture() now supports set the positioning of a picture, relate issue #214
• Function GetCellValue() now supports read inlineStr type cell value, relate issue #208 and pull request #209
• Function AddChart() now supports set custom chart size
• Add 3D, 3D 100%, clustered, stacked and 100% stacked bar and column series charts supported, relate issue #160 and #190
• Add a hyperlink to image support for the function AddPicture(), relate issue #185
• Add protection properties associated with the cell support, relate issue #191
• Add categories or values on reverse order (orientation of the chart) support, and set auto or fixed maximum, minimum of the axis, relate issue #202

Bug Fixes

• Fix DeleteSheet() make broken file caused by activeTab tag calculation wrong, relate issue #165
• Fix read columns count wrong in specific worksheet data, relate issue #175
• Handle special shared string table file name xl/SharedStrings.xml to make library compatibility with 1C software, relate issue #188
• Fix checkCellInArea() index out of range when the merged cell reference is single coordinate, relate issue #206
• Fix set font-family doesn't work, relate issue #222

Performance

• Make SetCellStyle() quicker by skipping conversions in checkCellInArea(), and skipping area checks when we are sure the cell can't be before or past the current row/col
• Save bytes on memory instead of string, 11% memory savings, see Performance Figures