v1.3.0
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()
andGetRowHeight()
, 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()
andSetRowOutlineLevel()
has been added for suppport creat group - Add iterator method for
Rows
, new functionsColumns()
,Next()
andError()
has been added - Function
SetCellValue()
now supportsbool
andtime.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 readinlineStr
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 byactiveTab
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 incheckCellInArea()
, 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