We are pleased to announce the release of version 2.8.1. Featured are a handful of new areas of functionality and numerous bug fixes.
A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.
Release Notes
The most notable changes in this release are:
Breaking Change
Upgrade requirements Go language version is 1.18 or later, for upgrade of dependency package golang.org/x/net
Change the data type for the HeaderFooterOptions structure fields AlignWithMargins and ScaleWithDoc as a pointer, resolve issue #1645
Remove unused exported data structure ShapeColor
Notable Features
Add new exported function SetCellUint, related issue #1681
Add new exported function GetPictureCells for get all picture cells, related issue #1218
Add new exported function GetConditionalStyle for get the conditional format style definition, related issue #1690
Add new exported function GetHeaderFooter for get the worksheet header and footer
Add new exported function AddSlicer for adding table and pivot table slicers
Add new exported function GetPivotTables for get pivot tables
Add new exported function DeletePivotTable for delete pivot table
Add a new Name field in the PivotTableOptions to support specify pivot table name
New support 7 formula functions: DBCS, SEARCH, SEARCHB, TEXT, TEXTAFTER, TEXTBEFORE and xlfn.ANCHORARRAY
Add export ChartLineType enumeration to specify the chart line type, related issue #1706
Add new Border field in the Chart data type to set the chart area border
Add new Type field in the ChartLine type to set the line type
Add new exported source relationship and namespace NameSpaceSpreadSheetXR10, ContentTypeSlicer, ContentTypeSlicerCache, and SourceRelationshipSlicer
Add new exported extended URI ExtURIPivotCacheDefinition
Allow dot character in the defined name, table name, or pivot table name
Keep all cells value in the table range when deleting table
Support format cell value with fraction number format code
Support delete image files from the workbook internally when deleting pictures to reduce generated workbook size and resolve potential security issues
Support set the height and width for the comment box, related issue #1688
Support update conditional formatting, data validations, defined names, drawing objects, formula reference and volatile dependencies on inserting/deleting columns/rows, related issues #1306 and #1615
Support 6 new kinds of conditional formatting types: text, blanks, no blanks, errors, no errors and time period
Support calculate formula with multiple dash arithmetic symbol
Support copy conditional format and data validation on duplicate row, related issue #1729
Support unset custom row height if the height value is -1 when using the SetRowHeight function
The SetRowHeight function will return an error if given an invalid row height value
The AddChart function support set the data labels position for the chart, related issue #1704
The AddChart function support set solid color or transparent fill for chart area, plot area, and maker, add a new field Fill in Chart, ChartPlotArea, and ChartMarker data type, related issue #1786
The AddChart function support set chart axis font family, size and strike style, related issue #1809
Add new field DataLabelPosition in the ChartSeries data type, support to sets the position of the chart series data label
Add new field BubbleSize in the Chart data type, support set the bubble size in all data series for the bubble chart or 3D bubble chart
Add new exported ChartDataLabelPositionType data type
The GetPictureCells and GetPictures function support get embedded cell images created by Kingsoft WPS™ Office, related issue #664
The SetConditionalFormat function support set conditional formatting with multiple cell ranges, related issue #1783
... (truncated)
Commits
688808b This closes #1819, formula calculation engine support array formulas
02b84a9 This closes #1820, converted styleFillVariants from slice to func (#1821)
ee2ef15 This closes #1815, cell value reading functions inherit the Options settings ...
9cbe3b6 This closes #1807, calculation engine support date and formula type cell (#1810)
bba155e This closes #1805, support set chart axis font family, size and strike style ...
a258e3d Fix CalcCellValue does not return raw value when enable RawCellValue (#1803)
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency
- `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
Bumps github.com/xuri/excelize/v2 from 2.8.0 to 2.8.1.
Release notes
Sourced from github.com/xuri/excelize/v2's releases.
... (truncated)
Commits
688808b
This closes #1819, formula calculation engine support array formulas02b84a9
This closes #1820, converted styleFillVariants from slice to func (#1821)ee2ef15
This closes #1815, cell value reading functions inherit the Options settings ...9cbe3b6
This closes #1807, calculation engine support date and formula type cell (#1810)bba155e
This closes #1805, support set chart axis font family, size and strike style ...a258e3d
Fix CalcCellValue does not return raw value when enable RawCellValue (#1803)99e91e1
This closes #1794, add new GetBaseColor function (#1798)9a68553
This closes #1792, support to update defined names reference when rename work...e4497c4
ref #65, new formula function: DBCS (#1791)9b07898
This closes #1789, delete VML shape on delete comment (#1790)Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase
.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show